Difference between revisions of "Db-preservation-toolkit"

From COPTR
Jump to navigation Jump to search
(Features: Link to SIARD format)
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
<!-- Use the structure provided in this template, do not change it! -->
+
{{Infobox tool
 
+
|purpose=Enables conversion between database formats or dumping from live database systems for the purposes of preservation.
{{Infobox_tool
+
|homepage=https://www.database-preservation.com
|name=db-preservation-toolkit
 
|purpose=Database Preservation Toolkit
 
<!-- |image=image.png -->
 
|homepage=http://keeps.github.io/db-preservation-toolkit/
 
 
|license=LGPL v3
 
|license=LGPL v3
 
|platforms=Platform independent - Java
 
|platforms=Platform independent - Java
 +
|function=File Format Migration
 +
|content=Database
 +
|name=db-preservation-toolkit
 
}}
 
}}
 +
{{Infobox tool details
 +
|ohloh_id=db_preservation_toolkit
 +
}}
 +
== 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)
  
<!-- Add one ore more categories to describe the function of the tool. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). The following are common category examples, remove those that don't apply -->
+
Database Preservation Toolkit can convert any of the above DBMS to the following preservation formats:
[[Category:Metadata Extraction]]
+
* SIARD 1
[[Category:Preservation System]]
+
* SIARD 2
 +
* SIARD DK
  
<!-- Add relevant categories to describe the content type that the tool addresses. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). If the tool works on any content type, do not add a category. The following are common category examples, remove those that don't apply -->
+
The Database Preservation Toolkit is also capable of loading preserved databases into any of the above DBMS.
[[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.
+
== User Experiences ==
 +
<!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
  
== Features ==
+
* https://zenodo.org/record/1171715
At the current version (1.0.0) the following database management systems import/export modules are supported:
+
* https://zenodo.org/record/1173099
* MySQL
+
* MS SQL Server
 
* MS Access
 
* Oracle (untested)
 
* PostreSQL
 
* DBML (Database Markup Language)
 
  
Additionally it is possible to export a database management system to a specific database SQL using the following export modules:  
+
== Development Activity ==
*PostgreSQLFile
+
Code is being actively developed at [https://github.com/keeps/db-preservation-toolkit Database Preservation Toolkit GitHub repository].
*MySQLFile
+
*SQLServerFile
 
*GenericSQLFile
 
  
More import/export modules are being developed at the current time being '''DB2''' one of them.
+
=== Release Feed ===
Besides, it is also being developed the modules to support the '''SIARD''' database preservation format [[formats:SIARD]]. (2014-03-11)
 
  
<!-- == User Experiences == -->
+
https://github.com/keeps/db-preservation-toolkit/releases 
<!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
+
 +
=== Activity Feed===
  
== Development Activity ==
+
https://github.com/keeps/db-preservation-toolkit/commits/master
Code is being actively developed at [[https://github.com/keeps/db-preservation-toolkit Database Preservation Toolkit GitHub repository]] and [[https://github.com/miguelsc/db-preservation-toolkit Database Preservation Toolkit GitHub Forked repository]]. Lastest version is db-preservation-toolkit 1.0.0 (release at 2013-09-10).
+
  
 
<!-- Add the Ohloh.com ID for the tool, if known. -->
 
<!-- Add the Ohloh.com ID for the tool, if known. -->
{{Infobox_tool_details
 
|ohloh_id=db-preservation-toolkit
 
}}
 

Latest revision as of 14:14, 24 September 2021



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
Function:File Format Migration
Content type:Database


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


Description[edit]

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[edit]


Development Activity[edit]

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


Release Feed[edit]

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

Activity Feed[edit]

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