Replacing Warehouse and Moving Data

[OUCATS]

I have just purchased a new server that will be replacing our current data warehouse. I would like to explain what I plan to do and see if everything sounds correct.

1. Install SQL Server & setup SQL Server Name
2. Update to current Service Pack
3. Move current databases to new server
4. Test

The one big question I have is about the current server name and the new server name and data connectivity. The current SQL Server is called "Server1" and the new SQl Server will be called "Server2". But when I transfer the databases, I will leave them all called exactly what they are now. So as far as connectivity goes, I believe I will have to visit every maching (13 approx) and change the Data Sources (ODBC) to point to the new server. After I do that, will all the current applications and access databases automatically find the databases (since I didn't change the database names)??

Also, is there anything I should look out for as I transfer servers??

Thanks!!

 

[fluteplr]

You will need to transfer the logins also.

There have been a number of threads here on how to do that.

The rest of your assumptions should be correct. If the database names are not changed all you need to do is point the odbc connection to the correct server.