iDamix (2/28/2011)
Hi,I've loaded a few hundred XML files into a SQL Server 2008 DB and need to show that the data was accurately replicated.
I'd like to take 10% of each table (each XML files corresponds to a table) and check them against the XML file. Or vice versa, it doesn't really matter.
It is easy to select 10% of each table at random, but does anyone have an idea on how to check it against the XML files?
Thanks in advance.
This is a bit like the mouse guarding the cheese. 😉 The same methods that you used for importing the data would be the same methods you'd use to check the data.
--Jeff Moden
Change is inevitable... Change for the better is not.