Messages

1

General Board / Re: How to Move EA Databases to a new sql server

« on: July 13, 2009, 10:49:26 pm »

Will try that today ( hopefully)

2

General Board / Re: How to Move EA Databases to a new sql server

« 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?

3

General Board / Re: How to Move EA Databases to a new sql server

« 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?

4

General Board / How to Move EA Databases to a new sql server

« 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.

5

General Board / Moving SQL Databases

« on: March 13, 2009, 01:14:09 am »

Hello,

I'm fairly new to the app from a Systems Admin perspective.  I am planning on moving our EA db from sql 2k5 server to another here on our network.  In addition, we have shared keys for the app which will be moving to another server as well.  I realize that I will need to remap my users to the EAKeyStore directory on the new server but are there any other caveats I need to know about before attempting this?