Exporting data with primary keys

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  February 19, 2018 at 6:51 am

  #327572

  Good day,

  I want to export data from one table to another using export and import wizard,i realised that the primary keys are not exported ,Is there a way to play around it  without scripting the table first.

  Thanks

• subramaniam.chandrasekar

  SSCarpal Tunnel

  Points: 4223

  More actions

  February 19, 2018 at 7:01 am

  #1980263

  tmmutsetse - Monday, February 19, 2018 6:51 AM

  Good day,

  I want to export data from one table to another using export and import wizard,i realised that the primary keys are not exported ,Is there a way to play around it  without scripting the table first.

  Thanks

  What about this ?

  https://www.sqlservercentral.com/Forums/Topic594018-149-1.aspx

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 19, 2018 at 7:12 am

  #1980267

  tmmutsetse - Monday, February 19, 2018 6:51 AM

  Good day,

  I want to export data from one table to another using export and import wizard,i realised that the primary keys are not exported ,Is there a way to play around it  without scripting the table first.

  Thanks

  Why do you not want to script the table?  If you don't, though, then just script the primary key constraint. Expand the table, expand Keys, right-click on the primary key constraint and choose Script Key as -> CREATE To -> Clipboard.

  John