Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Question Unanswered: Exporting Table Doesnot export identity and primary key relationship

    I exported a table from my DEV server to QA using export option of SQL 2005 all data got exported but keys like primary key doesnot got exported neither the properties like identity column got exported... this table which i am exporting was never there on QA server ...


    any way to transfer properties of the table ,...... so that everything gets exported along with data ..

    please help!!

  2. #2
    Join Date
    Oct 2003
    Posts
    60
    Use SSIS instead of just Export.

    Use the Transfer SQL Server Objects Task. It will do what your asking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •