Need help migrating instances from 7 -> 2000

[klamerus]

Would anyone knokw how to migrate non-database objects in a SQL Server instance?

We need to move about a dozen servers (with dozens of databases and packages, etc. in them) from SQL Server 7 to SQL Server 2000.

We cannot afford to do this one-by-one manually with export and import. Moreover, we need to move not just the databases, but also bunches of DTS packages between these instances. We are actually going from one server to another (the SQL Server 7 is on Windows NT, the SQL Server 2000 is on Windows 2003).

Is there anything that will copy/migrate the contents of an entire SQL Server instance like this?

 

[gmmastros]

In my opinion, the easiest way is to detach the databases from the SQL 7 instance, copy them to the new server, and then attach the databases to the SQL 2000 instance. When attaching a SQL 7 database to a SQL 2000 instance, the database will be upgraded automatically to a sql 2000 database.

I'm not sure about the DTS packages. sorry.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mutley1]

George,

Unfortunately I have moved to a company with no SQL 7, but at my last place I have a nagging feeling in the back of my mind that I upgraded a test server to 2000 and weeks later was saving DTS packages from the live system to the test system with no issues. I believe you can just save to SQL Server and select the new server.

As I say, no guarantees, but something in the old grey matter leads me to believe I did this before. Worth trying in the test phase!

BR,

M.