SQL Server Performance Forum – Threads Archive
Application cutover to new serverHi I have migrated my two database to another server(SQL7.00 to SQL2000) .Now i want to cutover my application from my old server to new server. Unfortunatly i cant do any R&D on this. Does anyone has any Document on Application cutover and things to be taken care. Thanks in advance.
Do you mean to tell the application to point to the new Server?
If so, connect the application to the Server through DSN and Modify that DSN if the server changes
Madhivanan Failing to plan is Planning to fail
If you want to make sure that no one connects to the old database , take the old database offline on the old server .. Check if you are using any linked servers in any stored Procedures. if you are changing the name of the server… Venu