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.
mi***@netins.com