Need a fast way of switching between databases on two servers. (ODBC)
Posted on 2004-04-07
We have two identical MS SQL data-bases that we need to switch between several times per day. (Test and development).
It is quite tedious to: Start the ODBC-administrator in the Control Panel. Find the Data Source. Click Configure. Change the Server Name. Click Next. Insert the Password. Click Next. Click Next. Click Finish. Click OK. Click OK.
There should be some kind of script available or similar...?
Clients: WIN 2000 PRO, WIN XP PRO. Servers: WIN 2000 Server. DataBase: SQL Server 2000.