Update database server - EA12

[jami]

Hi,
I'm currently working on EA12.1.
I have SQL Server 2012 Standard and Windows Server 2012 R2 Standard. I need to update the database server along with the operating system. Will EA12.1 work without problems on higher versions of the database server?

[Geert Bellekens]

Yes.

The only issue problem we had after upgrading was that certain queries were suddenly slow.
this was solved by setting the compatibility setting to 2019 (on SQL Server 2019)
By default this is set to the version you are upgrading from (2012) but that is not necesarry.

also make sure you update the schema to the latest version possible, as things like ntext have become obsolete in the current versions of SQL Server.
Check the download section on the website to get a hold of the update script for the database schema.

Geert

[jami]

Thank you very much.
I found this information next to the download section:
"This schema update is NOT backwards compatible, after applying it the model is only compatible with Enterprise Architect Version 14 and later. Sparx Systems recommend that all users update to Enterprise Architect 14 before applying this script.

This is for EASchema_1220_SQLServer.sql

It follows that this scheme will not work with version 12.1

[qwerty]

It depends. As long as the V14 user do not utilize that specific features you can still cross-work with V14 and previous ones. However, more sooner than later users will (accidentally) make use of new features. However, it proves that EA is quite robust and the worst that happens is that pre V14 users may not see the new features or can not apply them as V14 users. All said with a grain of salt. Backups are essential :-)

q.

[Geert Bellekens]

That warning is only for the (optional) update EASchema_1220_SQLServer_Update1.sql
You can update to that one after upgrading. (which is long overdue if you are still in v12.1)

Geert

[jami]

Thanks for the advice.
So I update the schema first and then the database? Does the order of operations not matter?

[Geert Bellekens]

Thanks for the advice.
So I update the schema first and then the database? Does the order of operations not matter?

What you mean mean by update schema/database? Isn't that twice the same thing?

Geert

[jami]

Update schema from SPARX and update database server (SQL Server 2012).

[Geert Bellekens]

No, I don't think it really matters.

Geert