Import database from SQL Server 7 into SQL Server 2000

[gudia97]

I have a database in SQL server 7 on an NT server 4 (S1), which is in domain D1. I have SQL server 2000 installed on a Windows 2000 server (S2) in a different domain.

I want to transfer the ENTIRE database from SQL 7 to SQL 2000.

Same users exist on Windows 2000 server (S2) as they exist in the NT server (S1) environment. S1 and S2 can see each other (ping each other) because they are on the same LAN segment.

 

[fluteplr]

I would try a backup and restore. You can restore 7 to 2000 but not the other way around.