August 14, 2011 at 4:11 pm
I would like to check for the accuracy of the merge and insert statements that I am using to migrate data between databases. They are not producing any FK/PK constraint or duplicate record errors. From that perspective alone, all seems to have gone well, and all data is in target.
But, I need to check my work. Is there a way to output the set of data that is being brought over for each WHERE MATCHED or WHERE NOT MATCHED and INSERT clause?
Will others please advise on techniques that they use, post data migration, to verify that data is making it across properly?
thank you!
August 14, 2011 at 4:14 pm
You can use the output clause in merge. BOL has good exemples.
August 14, 2011 at 4:25 pm
thanks for that. I needed a term. bingo!! 🙂
August 14, 2011 at 5:41 pm
Been there... google is awesome ONCE you know what you're looking for 😉
HTH.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply