Primary keys are not exported!

• Lisa-126581

  Newbie

  Points: 1

  More actions

  January 30, 2004 at 10:39 am

  #106872

  Dear experts,

  I am trying to export my tables from one database to another database and I realize that my Primary keys (all the IDs) are not exported at all. 

  Fx: I have 1 table (Customer) in my DB1.

  Here are all the fieldnames:

  CustomerID (primary key)

  CustomerLastName (text)

  CustomerFirstName (text)

  I exported it to DB2, I only 2 fieldnames (CustomerLastName and CustomerFirstName).  I wonder why CustomerID is not in my DB2???

  And does anybody know the difference between export/import???? 

  THis is my first time to post my questions here and I am exciting to hear from you

  THank you in advance. 

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 30, 2004 at 1:48 pm

  #492406

  I believe you choosed "copy table and views from source database". instaed, you should use "Copy objects and data between SQL Server databases".