How to Move EA Databases to a new sql server

[Keith Weitz]

Is there any documentation out there that shows how to move the EA databases from one sql server to another?  I need to retire an old sql server and I need to move all the EA db's to the other server.  I'm looking for which db's and log files need to be specifically moved as well as any adjustments that need to be made in the application.

Thanks.

[Eve]

EA allows for you to transfer your models with Tools | Data Management | Project Transfer.

You'll still need to know your source database and have created the schema on the target server though.

[Keith Weitz]

Great!  Thanks for the info.   I've created a target db on the new server and ran the SQLServer-BaseModel.sql script on it.  Is that sufficient to prep for the Project Transfer or do I not need to do that much?

[Eve]

That should be all.  But if you look at http://www.sparxsystems.com/uml_tool_guide/uml_model_management/upsizingtosqlserver.html the only different is the source datasource in step 3.

[Keith Weitz]

Ok, I went to do the project transfer.  It bombed on t_snapshot transfer with an out of memory error on the notes field.  The overall project is over 3 gigs.  Using version 7.1.828.  I did a project compare and there are ~16500 records in there

Any ideas?

[Geert Bellekens]

How about restoring the backup of the database onto the new server?
I've done a couple like that and it worked like a charm. (and it is a lot faster)

Geert

[Keith Weitz]

Will try that today ( hopefully)