Home All Groups Group Topic Archive Search About

Copy All Table/Index DDL + Data

Author
4 Aug 2006 5:37 PM
Jordan S.
Is there a quick and easy way, using Management Studio, to copy a table from
one database to another? While I found the SQL Server Import and Export
Wizard, I found that when executed, it moves the data and creates a minimal
table definition; the table was missing its indexes and primary key
definitions, etc.

Old school DTS let me specify such things. Do I really need to go to SSIS to
do this in 2005?

Thanks!

AddThis Social Bookmark Button