[dba-SQLServer] Any gut feelings?

Doris Manning mikedorism at verizon.net
Fri Nov 3 16:37:19 CST 2006


Can I claim this one too?  

<snip>Next YouDaMan prize goes to the one who provides the syntax to
transfer an entire table - structure, data and indexes intact, from one db
to another. That ought to slow you folks down! <snip>

Check out Data Transformation Service (DTS) in Enterprise Manager.  There is
a wizard that walks you through it.  You set up the from connection (server
and database) and to connection (server and database).  You pick the objects
you want to transfer and off they go.

Doris Manning
Hargrove Inc. 

More information about the dba-SQLServer mailing list