Best way to migrate SQL version 7 databases to 2000

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.comConsider using backup-restore method. It works rather well.

--
Dean Savovic
www.teched.hr

"Mike Czizek" <Mikec@.netins.net> wrote in message news:bnts03$5b8$1@.ins22.netins.net...
> 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

best way to migrate dts pkg to other box?

Hi what is the best way to migrate DTS package to other box? Thanks.
The easiest way to move it is to bring it up in the DTS Designer and then
save it onto the other box. Keep in mind now you might also need to change
your connection information when you move it to a new box.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"flologic" <flo@.flo.net> wrote in message
news:eUSMw0hhEHA.4064@.TK2MSFTNGP12.phx.gbl...
> Hi what is the best way to migrate DTS package to other box? Thanks.
>

best way to migrate dts pkg to other box?

Hi what is the best way to migrate DTS package to other box? Thanks.The easiest way to move it is to bring it up in the DTS Designer and then
save it onto the other box. Keep in mind now you might also need to change
your connection information when you move it to a new box.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"flologic" <flo@.flo.net> wrote in message
news:eUSMw0hhEHA.4064@.TK2MSFTNGP12.phx.gbl...
> Hi what is the best way to migrate DTS package to other box? Thanks.
>

best way to migrate dts pkg to other box?

Hi what is the best way to migrate DTS package to other box? Thanks.The easiest way to move it is to bring it up in the DTS Designer and then
save it onto the other box. Keep in mind now you might also need to change
your connection information when you move it to a new box.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"flologic" <flo@.flo.net> wrote in message
news:eUSMw0hhEHA.4064@.TK2MSFTNGP12.phx.gbl...
> Hi what is the best way to migrate DTS package to other box? Thanks.
>

Best Way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
databases to the new machine.
Thanks in advance,
Fabio
I like BACKUP and RESTORE, but sp_detach_db and sp_attach_db also work.
Here are some KB articles for you:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Fabio" <fabio@.glb.com.br> wrote in message
news:ugv$2CF6EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
all
> databases to the new machine.
> Thanks in advance,
> Fabio
>

Best way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
that new hardware.
Thanks in advance,
Fbio Augusto
First option I would go about is backup/restore. You can consider
detach/attach also.
Thanks
GYK
"Fabio" wrote:

> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>
>
|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fabio" <fabio@.glb.com.br> wrote in message
news:%23ZYDHJg4EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
> all
> that new hardware.
> Thanks in advance,
> Fbio Augusto
>

Best way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
that new hardware.
Thanks in advance,
Fábio AugustoFirst option I would go about is backup/restore. You can consider
detach/attach also.
Thanks
GYK
"Fabio" wrote:
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>
>|||http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"Fabio" <fabio@.glb.com.br> wrote in message
news:%23ZYDHJg4EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
> all
> that new hardware.
> Thanks in advance,
> Fábio Augusto
>

Best Way to migrate databases

Hi all,
What is the best way to migrate all databases from one sql server to
another?
We are buying a new hardware for the database server and we need to move all
databases to the new machine.
Thanks in advance,
FabioI like BACKUP and RESTORE, but sp_detach_db and sp_attach_db also work.
Here are some KB articles for you:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
Keith
"Fabio" <fabio@.glb.com.br> wrote in message
news:ugv$2CF6EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> What is the best way to migrate all databases from one sql server to
> another?
> We are buying a new hardware for the database server and we need to move
all
> databases to the new machine.
> Thanks in advance,
> Fabio
>