Any way to Include table data without setting Primary Key

GurpreetGill · February 20, 2019 5:14AM

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.

Thanks
Gill

Eddie D · February 21, 2019 10:50AM

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

GurpreetGill · February 21, 2019 10:52AM

ok thanks Eddie!!!

Any way to Include table data without setting Primary Key

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk