Hello!!=20

I have a Data Base in sql7 and I want to transfer to another PC with a =
clean installation of SQL2000. How do I do this?

You can both attach and restore 7.0 databases into 2000:


Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071

Moving Databases between Servers
http://www.support.microsoft.com/?id=314546

Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465

How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133

Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897

Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp

How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872

User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001

Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/


[quoted text, click to view]

I have a Data Base in sql7 and I want to transfer to another PC with a clean installation of
SQL2000. How do I do this?

Thanks!!