DataQ Logo
A collaborative platform for answering research data questions in academic libraries

What is the best way to preserve a SQL database for reuse?

Yasmeen.Shorish's picture
Answers: 
1
Tags: 
Topic: 
Yasmeen.Shorish's picture
There are several approaches one could take to preserve a relational database. Most databases (MySQL, PostreSQL, SQLServer) will create text files that provide relationships associated with the tables as well, which will capture foreign key relationships, indices, etc...Other tools, such as mysqldump and schemacrawler may be best for database back-ups and migrations. For more interoperability across operating systems, http://www.database-preservation.com/ and https://github.com/ViDA-NYU/reprozip may be more appropriate, although you will want to make sure you do not get 'locked' into a particluar tool in order to re-use. Regardless, you will want to associate your database with as much supporting documentation as is reasonable to maximize re-use.