I have to move data from 2000 tables from one Server to another (total 10
million records). The Servers are physically in different locations. Is
there an easy way to create a DTS package to do the same? I have tried the
import/export and if I pick up more than 25 tables at a time, it takes
forever to just create and save the package. Backup/Restore or attach/detach
in not an option. Any help in this regard is appreciated.

Thanks.

In message <#t#K2rncFHA.2288 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, XXX <sa (AT) nomail (DOT) com>
writes
Use the Wizard to create several packages, 10 tables at a time. This
should get round the big package problem.

Also you may want to look at replication or log shipping perhaps?

Backup and restore would probably be the best method though, maybe
re-evaluate the constraints you have?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org