Migrating Repositories

Hi,

we're in the process of moving our repository from an Oracle db (ER/Studio18.0) to MS SQLServer Repository ((ER/Studio18.0).  

Is the an easy ways to export the complete repository from the old machine and re-import it on the new server? I've looked online and cant see any documentation for this.

Saving the diagrams and re-opening them causes a message to complain that the diagram machine id's do not match. Also using the export facility results in the diagram submodels and formatting to be destroyed

Kind regards

Andy Williams

  • I've not looked at the underlying repository tables in other DBMS deployments.  But if the tables are similar enough, have you considered using any ETL/migration tools you might have?  Such as Azure Data Factory or SSIS?