mikedorism at verizon.net
Fri Nov 3 16:37:19 CST 2006
John, 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