How can we help you today? How can we help you today?

Any way to Include table data without setting Primary Key

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
GurpreetGill
0

Comments

2 comments

Sort by
  • 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
    Eddie D
    0
  • GurpreetGill
    ok thanks Eddie!!!
    GurpreetGill
    0

Add comment

Please sign in to leave a comment.