I want to migrate a SQL Server Erwin data Mart database to Aurora and trying to figure out what the easiest/quickest way to do that is.
Options to me seem to be:
- Saving models to the file system, repoint the application to the new mart database, then loading from the file system to the new database. https://support.erwin.com/hc/en-us/articles/360003443452-Java-scripts-that-automatically-save-a-mart-s-models-offline-to-a-drive [support.erwin.com] https://support.erwin.com/hc/en-us/articles/115002674131-ERWIN-DATA-MODELER-MART-API-RESOURCE-PAGE [support.erwin.com]
Has anyone got any experience using these apis?
- Export/Import. Mysql migration tool. https://www.mysql.com/products/workbench/migrate/
Amazon migration tool Does anyone know if the schema is the same, can I simply export/import the data?