[Archivesspace_Users_Group] Migrating data from Derby to MySQL

Chris Fitzpatrick Chris.Fitzpatrick at lyrasis.org
Tue Sep 22 12:09:58 EDT 2015


Yes, I'm tried to migrate data from deby to mysql a couple of times and never have very good results.

Your best options are probably to start another instance of ArchivesSpace using mysql and either:

a) write a script that transfers data from one REST API endpoint to another


b) manually copy/paste data from one to the other.


Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Levy, Michael <mlevy at ushmm.org>
Sent: Tuesday, September 22, 2015 4:35 PM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] Migrating data from Derby to MySQL

Let's say, hypothetically, that one has entered some test resources into ArchivesSpace and in the fullness of time those test data grew, and then one takes a look at what one has and thinks, hmm, it would be nice to migrate from Derby to MySQL. In this hypothetical scenario, what advice would you give? Find a way to export and import the Derby table data to the empty MySQL database created at install? Are there better export/import functions provided by ArchivesSpace?

We know now to avoid production data in Derby.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20150922/689549d3/attachment.html>

More information about the Archivesspace_Users_Group mailing list