Migration Repository

[Alain PERSIN]

Hello !
I am using EA and my repository is hosted on a SQL Server 2008 R2 database.
I need to move this database to a SQL Server 2014 instance.
How can I do ?
Should I create an empty database on the target instance and do a repository transfer?
Will there be a compatibility issue if I upgrade from 2008 to 2014 SQL Server Instance?
Thanks for your feedback.
Regards.

[qwerty]

Should be no issue. Use the DB creation scheme from Sparx and then trigger a Configure/Model/Transfer or where ever that in your current EA version might lurk) in EA from the old to the new DB.

q.

[horszasz]

Hi,

Should I create an empty database on the target instance and do a repository transfer?

Definitely yes.

Will there be a compatibility issue if I upgrade from 2008 to 2014 SQL Server Instance?

No, if you are using the most current database stucture in your 2008 DB , you do not need to calculate with any comptibility issue.

Regards,
Gergely

[Geert Bellekens]

No, you can simply restore the backup from SQL 2008 on your SQL 2014
That is much much faster.

You may want to look at updating your schema to the latest if you have not already done that. (check the SQL server schema file downloads), but that is not strictly related to the SQL server upgrade.

After restoring the database you can set the compatibility level to SQL 2014 (I had some issues with performance when the compatibility level was set to 2005)

Geert