Syncing bulk data into SQL Server using DataTable, SQLBulkCopy & SQL MERGE

These days (for the most part) I'm an advocate of using a (micro) ORM for most CRUD operations - delving into SQL usually isn't justified. That said, with clients I've had over the years I've seen a recurrent need for a "bulk data sync" process - essentially take a feed of data from an external system and "merge" it into a table in our database. Any records that are matched should be updated, any records that don't exist should be…


End of content

No more pages to load