What are the challenges you face when working across database platforms? Take the survey

Any way to Include table data without setting Primary Key

GurpreetGillGurpreetGill Posts: 26 Bronze 1
edited February 20, 2019 8:05AM in SQL Change Automation
I have an existing table without primary key, which is having data. I want to include this data as part of migration script. Is there any way to do so?
I know i can consider Bulk Insert or Merge, but my table's row are not fixed in count, it may varies.


Best Answer

  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5
    Hi Gill

    Thank you for your forum post.

    Sadly you need to configure a primary key.  In order to track the data within your table or tables, the table must include a primary.  Tables without a primary key are ignored and not imported.  Further reading in this help document.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com


Sign In or Register to comment.