Any way to Include table data without setting Primary Key

GurpreetGill

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

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

ok thanks Eddie!!!