SQL Database Schema upgrade

[Sunshine]

Just started at a new organisation and they have Sparx V51.1 with a SQL Server that appears to have been set up in 2004
Looked at the schema version in about dialog and got this

Connection / DBMS:  OLEDB - MS SQL Server
Database Version: 7.0
Version Date: Jan-31-2004

Boy thats old I thought.
Had a look at the upgrade scripts on the page https://sparxsystems.com/resources/repositories/index.html
And I see the following
Alter Scripts

• Schema 1220 to 1558 (between July 2016 and February 2021)
  
• Schema 851 to 1220 (between February 2010 and June 2016)
  

But can't find any scripts that go back to the version mentioned above.
Any suggestions how I can upgrade the schema?

[qwerty]

They didn't change too much over the years. You could compare the loaded schema with what you get from Sparx's currently published one. You should be able to figure out the diffs manually.

q.

[DeBAAT]

Just a thought:
Would it be possible to create a new repository with the latest schema and use the transfer option to migrate the old model to the new DB instance?

[Geert Bellekens]

Just a thought:
Would it be possible to create a new repository with the latest schema and use the transfer option to migrate the old model to the new DB instance?

Yes, I would think so.

You might also be able to upgrade using the upgrade scripts available on the website.

Geert