Migrating from 7 to 2000 
Author Message
 Migrating from 7 to 2000
Hi, i need to migrate a database and users from one server to another.
The question is: i have around 150 logins created on the SQL7 server,
how can i migrate them to 2000?
thanks
--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda

http://www.***.com/


Mon, 15 Aug 2005 22:39:05 GMT
 Migrating from 7 to 2000

Hello, Guillermo!

BACKUP and RESTORE would seem to be a good option but try these (From
A.J.Kelly)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546     Moving
DB's between Servers
Q246133   INF: How To Transfer Logins and Passwords Between SQL Servers
Q298897   Mapping Logins & SIDs after a Restore
Q168001   PRB: User Logon and/or Permission Errors After Restoring Dump
Q240872   How to Resolve Permission Issues When a Database Is Moved Between
SQL Servers

Q224071   INF: Moving SQL Server Databases to a New Location with
Detach/Attach

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Copy DB Wizard issues

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Hi, i need to migrate a database and users from one server to another.
: The question is: i have around 150 logins created on the SQL7 server,
: how can i migrate them to 2000?
: thanks
: --
: Guillermo Casta?o Acevedo
: Gerente de Sistemas - Grupo Millennium Ltda

: http://www.GrupoMillennium.com
      ---  Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2)
Gecko/20021120 Netscape/7.01



Mon, 15 Aug 2005 23:30:25 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Migrate from Old SQL 2000 server to a New SQL 2000 server

2. Migrating queries in Access 2000 to SQL Server 2000

3. migrating 6.5 databases to 2000 via Upgrade wiz

4. Migrating from SQL Server 2000 to SQL Server 7

5. Migrating a Microsoft Access 2000 Database to IBM DB2 Universal Database 7.2

6. Migrating Oracle to Sqlserver 2000

7. Migrate databases to SQL 2000

8. Migrating from 7 to 2000

9. Migrating 6.5 Data to 2000

10. Why migrate from 6.5 to 2000

11. Migrate to Win 2000/Sql 2000 from Win Nt/Sql 7.0

12. Cannot migrate from access 2000 to SQL 2000


 
Powered by phpBB® Forum Software