SQL Server: BulkMerge with Uniques

[mhesham93]

Is it possible to perform a BulkMerge with existing data and avoid merging duplicate records? if so can you please post a sample?

Thanks

[mikependon]

Hi @mhesham93 , no, it is not possible, it is either of "inserting a new record" or "updating an existing record" based on the qualifier.

[mhesham93]

Thanks Michael, so if I’m importing data from a file and then I re-import the file to update the records do I use update instead of merge to avoid this problem?

Thank you, Mohamed Said

---

From: Michael Camara Pendon @.> Sent: Thursday, April 22, 2021 4:08:40 PM To: mikependon/RepoDB @.> Cc: mhesham93 @.>; Mention @.> Subject: Re: [mikependon/RepoDB] SQL Server: BulkMerge with Uniques (#816)

Hi @mhesham93https://github.com/mhesham93 , no, it is not possible, it is either of "inserting a new record" or "updating an existing record" based on the qualifier.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/mikependon/RepoDB/issues/816#issuecomment-825150904, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACK2O3DXMFHTJQMWKSATX73TKB64RANCNFSM43LVZBKQ.