Monday, March 12, 2012

MIGRATIONSQL7 to SQL2000

Hello!!
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!!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 Server
s
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/
"Utopian" <gla1972@.yahoo.com.ar> wrote in message news:ORGDjc$JFHA.3516@.TK2M
SFTNGP10.phx.gbl...
Hello!!
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!!

No comments:

Post a Comment