merida2sql: Dump Merida Data to SQL
merida2sql is a command-line utility that converts a Merida database dump into an equivalent SQL representation. It processes a Merida dump directory together with a database definition file and generates SQL scripts that recreate the database structure and populate it with data.
The resulting SQL output is written to a target directory, along with a README file describing the steps required to import the data. This directory can be packaged and sent to a vendor to support migration from Merida to an SQL-based database system.
To perform the conversion, merida2sql requires:
- A Merida database definition file, which describes the database structure and is used to correctly interpret the dump files
- A Merida dump directory, containing data exported from Merida
- A target directory, where the generated SQL files will be written
- A database name, which will be used when creating the SQL database
An optional verbose mode provides progress information during execution, which can be useful for large databases.
Overall, merida2sql is intended as a migration aid, simplifying the process of transferring data from Merida into a standard SQL format that can be imported and handled by external systems or vendors.
Project lifetime: Aug 2015 - Nov 2016