Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Keith Weitz on June 25, 2009, 12:35:40 am

Title: How to Move EA Databases to a new sql server
Post by: Keith Weitz on June 25, 2009, 12:35:40 am

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.

Title: Re: How to Move EA Databases to a new sql server
Post by: Eve on June 25, 2009, 08:18:05 am

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.

Title: Re: How to Move EA Databases to a new sql server
Post by: Keith Weitz on June 25, 2009, 11:27:23 pm

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?

Title: Re: How to Move EA Databases to a new sql server
Post by: Eve on June 26, 2009, 09:05:03 am

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.

Title: Re: How to Move EA Databases to a new sql server
Post by: Keith Weitz on July 12, 2009, 12:39:10 am

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?

Title: Re: How to Move EA Databases to a new sql server
Post by: Geert Bellekens on July 13, 2009, 04:46:44 pm

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

Title: Re: How to Move EA Databases to a new sql server
Post by: Keith Weitz on July 13, 2009, 10:49:26 pm

Will try that today ( hopefully)