Export Table but Keep Indexes

I need to migrate some tables from my development database to the
production database. I have played with the export dts wizard but the
tables lose their keys and indexes. Is there a way to migrate a table
and keep the indexes and keys?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Make sure you use the right DTS option: "Transfer objects and data between
SQL Server databases", and check all relevant option inside that dialog.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Debbie" <anonymous@.email.com> wrote in message
news:uEE3qp1vDHA.2456@.TK2MSFTNGP12.phx.gbl...
> I need to migrate some tables from my development database to the
> production database. I have played with the export dts wizard but the
> tables lose their keys and indexes. Is there a way to migrate a table
> and keep the indexes and keys?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!