Hi Liz, I did a few data migrations from weird in house systems and filemaker to Emu/Axiell. Companies will generally want you to use their existing structures/layouts unless you have a huge budget for customization (which we did, I was working in Qatar at the time and they paid for a tech from the company to live and work on site with us - luxury!!). My first project was in England and we had low budget. The most important thing - and I recommend doing this yourself if you are the main user/admin of your existing system - or checking this thoroughly - is the data mapping stage. This is when you look at every field in your existing database and match it to the field it should go to in the new system. Some fields might have more or less functionality (ie link to a thesaurus or a drop down list etc). Also if you do data clean up before or in the middle of this process the end result in the new system will be much better. If you can have the users of the system work on this stage it is also ideal because then they will have an idea of where their data went. If you can stop all editing on your current system (leave it read only for users), export ALL the data into a spreadsheet and validate all of the data (ie make sure it should be there, fix any inconsistencies) BEFORE it gets migrated into the new system that is ideal too. OR if you notice some consistent mistakes you can give the migrating company rules to fix like 'make all dates like this YYYY MMM DD' for example. There will be a data entry black out period from the time you either start doing the data cleansing/validation to the time you get it back from the company in the new system so pick the timeframe wisely for this and be sure that you have that written into the contract so that it is clear of the expectations. You can give people spreadsheets formatted so they will migrate/import easily into the new system if it is mission critical to your operations. Also there should be a legacy field that is not editable by anyone, ever, in the new system that has the exact copy of all of the data from the old record somewhere in the new one. This field should be searchable so that if someone absolutely cannot find the record using the new system it will still come up. I'd also be sure to flag the fields that will be public or shared with departments in the data mapping process. So you need to know what fields all of your existing users use the most, and how they use them (edit, read only, reporting). Also check the user permissions and the possiblity of creating your own user groups or if they are off the shelf - you likely want a way to keep registrar data private (ie not accesible for deparments like education or marketing). I'd be happy to have a zoom call if you want to talk through any of this!
------------------------------
Dr. Laura Phillips
Lecturer, Museum Studies Master of Arts
School of Information and Library Studies
The University of Oklahoma
401 W. Brooks, Bizzell Library
Norman, OK 73019
laura.phillips@ou.eduI am grateful to be present on the homelands of the "Hasinais" Caddo Nation and "Kirikirʔi:s" Wichita & Affiliated Tribes. I acknowledge this territory also serves as a hunting ground, trade exchange point, and migration route for the Apache, Comanche, Kiowa and Osage nations. Today, 39 Indigenous Nations dwell in what is now the state of Oklahoma as a result of settler and colonial policies that were designed to assimilate and eradicate Indigenous peoples.
------------------------------
Original Message:
Sent: 01-29-2026 01:12 PM
From: Elizabeth Spencer
Subject: CMS Migration Advice
Hello,
I am a database administrator and my museum is researching future options for our CMS. Currently we use TMS but are looking into other systems. Is there anyone who might have made this type of transition and can share their experience with me? I would be interested even if it was not from TMS to another CMS - migrations in general. I would love to ask questions and hear about any migration issues, budgeting for the move, and hindsight thoughts that anyone can share.
I appreciate your help.
Thank you,
Liz Spencer
------------------------------
Elizabeth Spencer
------------------------------