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:
  1. The new machine has databases already on it that need to stay there.
  2. The new machine will be renamed and given the IP of the old machine so all of our applications/reports will not blow-up.
  3. 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!
_________________________
Donato
MkII/080000565
MkIIa/010101253
ricin.us