[Archivesspace_Users_Group] Migrating data from Derby to MySQL

[Chris Fitzpatrick]

Hi,


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

or

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



b,chris.



Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/


________________________________
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>