Focal Point
MSSQL Database is being Moved

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8841090313

January 09, 2009, 11:22 AM
Greg
MSSQL Database is being Moved
My MsSql database is being moved to a new server with a new name.

Do I just need to change the database name in the connection parameters?

Or do all of my synonyms need to be updated? I hope not as there over over 1000 of them that connect to the MsSql server.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

January 09, 2009, 11:27 AM
GinnyJakes
Yes, that would be one way if you are sure that the structures did not change.

Also, make sure you change the machine's ODBC connection to point to the right place.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google