I have an instance of SQL Server 2000 (SP3a) running on machine A. I want to export three databases on machine A and import them into machine B. There is no internet connectivity between the two machines.

Since I have about 100 tables between all three databases, I don't want to export on a per-table basis. In DTS , is there to make a copy of the database tables and data, that allow this kind of import/export. Maybe one export "file" per database.

Don't even bother with DTS. Just do a full backup of each db and restore
them on the other machine.


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


"Richard" <rtrujillo (AT) touchnet (DOT) com> wrote

There is no internet connectivity between the two machines.
database tables and data, that allow this kind of import/export. Maybe one
export "file" per database.