Okay guys, I've changed organisations and found they have SQL Server 2012 with a really old schema V7.0 2004 for Sparx EA with lots of useful models. I've organised an upgrade to SQL 2019 (Thats they latest they have) and created a new database with schema 1558 from the SQL creating Script 1518. The two scripts to upgrade the schema don't go back as far as the database we have. So far so good, got my new database with new schema set up. Just need to do a project transfer from the old SQL Server to new SQL server. The trouble I've encountered is it's been going for several hours and its still on t_xref table. I tried doing a SQL Server to a qea file the other day and it completed in 20 min. The DB isn't particularly large being around 1.6GB. The numbers of rows in the main tables look like this.
Table Name,Row Count,
t_xref,245754,
t_objectproperties,1261126,
t_object,172449,
t_diagramobjects,166265,
t_diagram,14227,
t_connector,104431,
t_attribute,62213,
Any ideas on how I can transfer from one SQL Server to another quicker, so it completes before I die of old age?
