|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy All Table/Index DDL + DataIs 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! |
|||||||||||||||||||||||