Migrating from SQL Server 7 to SQL Server 2000

[klamerus]

Help.

We have about a half dozen SQL Servers with between 20-60 databases each on them. These are all SQL Server 7 (on NT) and we need to migrate them to SQL Server 2000 (not ready for 2005 yet) on Windows 2000/2003 (don't know which yet).

We really (REALLY) don't want to export/import each of these databases, at least not manually.

Is there some tool that will move all these for us where we can at least just identify the server (instance) and not each individual database? It's gonna have to move everything in the DB (not just the tables and data).

Thanks,
Mark

 

[mrdenny]

The easiest way is to either backup and restore the databases, or detach and then attach the databases from the old server to the new server.

You can restore a SQL 7 backup to a SQL 2000 server as well as attach a SQL 7 MDF/LDF to a SQL 2000 server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[klamerus]

We don't want to backup/restore database-by-database.

We know how to do that (as I said).

We want to copy the contents of the entire server from the old to the new.

 

[mrdenny]

As far as I know there isn't any sort of tool that will poll a server and see what it's got, then migrate everything.

You could generate a script based on the contents of the SQL 7 server to attach the databases to the SQL 2000 server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com