Difference between revisions of "Db-preservation-toolkit"

From COPTR
Jump to navigation Jump to search
(Development Activity: Added Release and Activity Feed)
(3 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
|purpose=Enables conversion between database formats or dumping from live database systems for the purposes of preservation.
 
|purpose=Enables conversion between database formats or dumping from live database systems for the purposes of preservation.
 
<!-- |image=image.png -->
 
<!-- |image=image.png -->
|homepage=http://keeps.github.io/db-preservation-toolkit/
+
|homepage=https://www.database-preservation.com
 
|license=LGPL v3
 
|license=LGPL v3
 
|platforms=Platform independent - Java
 
|platforms=Platform independent - Java
Line 18: Line 18:
 
[[Category:Database]]
 
[[Category:Database]]
  
The Database Preservation Toolkit allows conversion between Database formats, including connection to live systems, for purposes of digitally preserving databases. The toolkit allows conversion of live or backed-up databases into preservation formats such as DBML, an XML format created for the purpose of database preservation. The toolkit also allows conversion of the preservation formats back into live systems to allow the full functionality of databases. For example, it supports a specialized export into MySQL, optimized for PhpMyAdmin, so the database can be fully experimented using a web interface.
+
== Description ==
 +
The Database Preservation Toolkit allows conversion between Database formats, including connection to live systems, for purposes of digitally preserving databases. The toolkit allows conversion of live or backed-up databases into preservation formats such as SIARD, a XML-based format created for the purpose of database preservation. The toolkit also allows conversion of the preservation formats back into live systems to allow the full functionality of databases.
  
== Features ==
+
The Database Preservation Toolkit supports the following Database Management Systems:
At the current version (1.0.0) the following database management systems import/export modules are supported:
+
* MySQL/MariaDB
* MySQL  
+
* PostgreSQL
* MS SQL Server
+
* Oracle
* MS Access
+
* Microsoft SQL Server
* Oracle (untested)
+
* Microsoft Access
* PostreSQL
+
* And other databases (using JDBC)
* DBML (Database Markup Language)
 
  
Additionally it is possible to export a database management system to a specific database SQL using the following export modules:  
+
Database Preservation Toolkit can convert any of the above DBMS to the following preservation formats:
*PostgreSQLFile
+
* SIARD 1
*MySQLFile
+
* SIARD 2
*SQLServerFile
+
* SIARD DK
*GenericSQLFile
 
  
More import/export modules are being developed at the current time being '''DB2''' one of them.
+
The Database Preservation Toolkit is also capable of loading preserved databases into any of the above DBMS.
Besides, it is also being developed the modules to support the '''SIARD''' database preservation format [[formats:SIARD]]. (2014-03-11)
 
  
 
== User Experiences ==
 
== User Experiences ==
 
<!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
 
<!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
 +
 +
* https://zenodo.org/record/1171715
 +
* https://zenodo.org/record/1173099
 
   
 
   
  
 
== Development Activity ==
 
== Development Activity ==
Code is being actively developed at [http://github.com/keeps/db-preservation-toolkit Database Preservation Toolkit GitHub repository] and [http://github.com/miguelsc/db-preservation-toolkit Database Preservation Toolkit GitHub Forked repository].
+
Code is being actively developed at [https://github.com/keeps/db-preservation-toolkit Database Preservation Toolkit GitHub repository].
 
   
 
   
  
 
=== Release Feed ===
 
=== Release Feed ===
Below the last 3 release feeds:
+
 
<rss max=3>https://github.com/keeps/db-preservation-toolkit/releases.atom</rss>
+
https://github.com/keeps/db-preservation-toolkit/releases
 
 
 
   
 
   
 
=== Activity Feed===
 
=== Activity Feed===
Below the last 5 commits:
+
 
<rss max=5>https://github.com/keeps/db-preservation-toolkit/commits/master.atom</rss>
+
https://github.com/keeps/db-preservation-toolkit/commits/master
 
   
 
   
  

Revision as of 09:26, 16 August 2018


Enables conversion between database formats or dumping from live database systems for the purposes of preservation.
Homepage:https://www.database-preservation.com
License:LGPL v3
Platforms:Platform independent - Java

Description

The Database Preservation Toolkit allows conversion between Database formats, including connection to live systems, for purposes of digitally preserving databases. The toolkit allows conversion of live or backed-up databases into preservation formats such as SIARD, a XML-based format created for the purpose of database preservation. The toolkit also allows conversion of the preservation formats back into live systems to allow the full functionality of databases.

The Database Preservation Toolkit supports the following Database Management Systems:

  • MySQL/MariaDB
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • Microsoft Access
  • And other databases (using JDBC)

Database Preservation Toolkit can convert any of the above DBMS to the following preservation formats:

  • SIARD 1
  • SIARD 2
  • SIARD DK

The Database Preservation Toolkit is also capable of loading preserved databases into any of the above DBMS.

User Experiences


Development Activity

Code is being actively developed at Database Preservation Toolkit GitHub repository.


Release Feed

https://github.com/keeps/db-preservation-toolkit/releases

Activity Feed

https://github.com/keeps/db-preservation-toolkit/commits/master


Error in widget Ohloh Project: unable to write file /var/www/html/extensions/Widgets/compiled_templates/wrt6621a5204ad130_79788206