sql server (alternate): Best way to migrate SQL version 7 databases to 2000 -- sql server (alternate)

Best way to migrate SQL version 7 databases to 2000

Mikec NO[at]SPAM netins.net
10/31/2003 2:35:47 PM

sql server (alternate): We are moving all databases from a SQL version 7 server to a version 2000
server. Which of the following is the preferred method?

1) Detach the DB on the version 7 server, move it to the new server via
Windows Explorer and reattach it there.

2) Use SQL Enterprise Mananger with the DTS Export Wizard to "copy objects &
data between SQL server databases" from the version 7 server to the 2000
server.

With the changing of the version, I thought maybe option 2 is best. Thoughts?

--
Mike Czizek
Iowa Network Services, Inc.
mikec@netins.com

Re: Best way to migrate SQL version 7 databases to 2000

Dean Savovic
10/31/2003 4:11:02 PM

Consider using backup-restore method. It works rather well.

--
Dean Savovic
www.teched.hr

[quoted text, click to view]