SQL 7.0 to SQL 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ctowndu33 - 28 Sep 2005 19:39 GMT

We currently have a production box running Windows NT server with SQL 7.0.
We also have the migration box running Server 2003 Std. and SQL 2000. How
can we migrate the data from the old server to the new server, making sure we
keep all information like usernames, passwords, etc.?

Reply to this Message

Keith Kratochvil - 28 Sep 2005 19:48 GMT

BACKUP and RESTORE
or
sp_detach_db and sp_attach_db
are the easy way to move your databases.

You will find this KB article very helpful in moving your users

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133

Signature

Keith

> We currently have a production box running Windows NT server with SQL 7.0.
> We also have the migration box running Server 2003 Std. and SQL 2000. How
> can we migrate the data from the old server to the new server, making sure
> we
> keep all information like usernames, passwords, etc.?

Reply to this Message

Hari Prasad - 28 Sep 2005 20:08 GMT

Hi,

See the below URL:- This articles details the clear method to upgrade.

http://www.sqlteam.com/item.asp?ItemID=9066

Thanks
Hari
SQL Server MVP

Reply to this Message