View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 06:53 AM
Anith Sen
 
Posts: n/a
Default Re: Table export removes primary key

On the next screen after specifying the destination server in DTS
import/export wizard, select the third option "Copy objects and data between
SQL Server databases", on the next screen, uncheck the "Use default options"
check box, click on the options button. A dialog box will provide the
required options to copy the keys, indexes, triggers etc.

--
Anith


Reply With Quote