Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: miamikk204 on May 06, 2020, 02:51:46 pm

Title: EA 14/15 SQL database migration/upgrade
Post by: miamikk204 on May 06, 2020, 02:51:46 pm

We got users using combination of EA v14 and v15. The current database is on SQL2008R2 and we are planning to move the database to another Server running SQL2016.
Can anyone advise

• There will be no compatibility issues with our current versions of EA and SQL 2016
• Is there a EA specific process we need to follow to migrate the database from one SQL Server to another SQL Server ? or we simply backup and restore the database
• How do we update the new SQL Server name in the EA Tool after migration ?
• Are there any specific checks/tests we need to do for EA after the database is migrated ?

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: Geert Bellekens on May 06, 2020, 03:11:20 pm

I've done a few of them, and there's really not much too it.

No compatibility issues or anything. One thing that we noticed was that a specific query was taking much longer on the new database. This was solved by setting the compatibility setting in sql server to match the version of the server.

If you haven't already, I would also recommend to "upgrade" your SQL schema with the upgrade script available on the website.
This gets rid if the ntext fields, who are deprecated anyway, and only cause headaches when querying.

I'm not sure what you mean by "update the new SQL Server name in the EA Tool after migration"

Geert

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: miamikk204 on May 08, 2020, 02:52:12 pm

In regards to [I'm not sure what you mean by "update the new SQL Server name in the EA Tool after migration" ], the underlying SQL Server is not being upgraded but instead the EA database will be moved old SQL Server to New SQL Server running SQL2016. After database has been moved, we will need the EA tool to connect to new SQL Server and I wanted to know how do we update the SQL Server name ?

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: Sunshine on May 08, 2020, 03:21:00 pm

Just create another DB connection in the same way you did the first one.
Worth noting those who use features available in the later version will be fine but those using an older version may not see those features

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: Geert Bellekens on May 08, 2020, 03:22:31 pm

You just need to connect to your new database like you did to your old database.
Choose server connection, then choose the right driver (Microsoft OLE DB Provider) and fill in the details of the database to connect.

Alternatively you can save the current connection as a shortcut (not encrypted) and edit the connection details in the shortcut file.

Geert

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: miamikk204 on May 10, 2020, 12:05:52 pm

Geert, can you confirm if this is still applicable as we not upgrading EA version "I would also recommend to "upgrade" your SQL schema with the upgrade script available on the website" ?

Title: Re: EA 14/15 SQL database migration/upgrade
Post by: Geert Bellekens on May 10, 2020, 03:27:34 pm

Quote from: miamikk204 on May 10, 2020, 12:05:52 pm

Geert, can you confirm if this is still applicable as we not upgrading EA version "I would also recommend to "upgrade" your SQL schema with the upgrade script available on the website" ?

Yes, still valid.

Geert