I need to take a server running MS SQL Server 7 on NT4 and clone all the databases, store procedures, views, etc to a new machine running MS SQL Server 7 on Win2k.
So, here's my question: What would be the most effective/efficient way to do this?
A few things to note:
- The new machine has databases already on it that need to stay there.
- The new machine will be renamed and given the IP of the old machine so all of our applications/reports will not blow-up.
- The old machine is to be completely retired, so this has to be a complete move.
Key thing is, this needs to be seamless, it is our primary database server for sales reporting, etc. I can't screw it up.
I've moved databases before, but not
entire collections of databases on one server like this.
Any help is greatly appreciated!