Difference between revisions of "Db-preservation-toolkit"

From COPTR
Jump to navigation Jump to search
m (Formatting)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<!-- Use the structure provided in this template, do not change it! -->
+
{{Infobox tool
 
 
{{Infobox_tool
 
|name=db-preservation-toolkit
 
 
|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 -->
+
|homepage=https://www.database-preservation.com
|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:File Format Migration]]
+
* SIARD 1
 
+
* 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 -->
 
[[Category:Database]]
 
 
 
== 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 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.
 
 
 
At the current version (1.0.0) the following database management systems import/export modules are supported:
 
* 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:
 
*PostgreSQLFile
 
*MySQLFile
 
*SQLServerFile
 
*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
 
   
 
   
  
 
<!-- 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/wrt67439507e0d5a7_92086417


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