|
As part of a software testing effort I need to compare the complete set of records stored in one 'version' of a MS-SQL 2005 database, to those from another 'version' of that DB (stored on a different server), and get a list of differences. My normal approach is to use BCP with Queryout to extract each table's records to a text file, concatenate those files into one large file (doing this for each DB), and then use a text-file-compare utility to scope out differences. The limitation of this method is that the text files don't distinguish a field containing a blank string ('') from a field containing NULL. The text file shows just a blank string in either case. Normally this distinction is unimportant but in this instance it's critical to my test results. So the questions:
(comments are locked)
|
|
Both Red Gate SQL Data Compare & Apex SQL Data Diff will do this for you...
(comments are locked)
|
|
You can also use Visual Studio 2008 Team system - database edition to compare the data (and schema). Another benefit with VS is that you may apply "best practice" rules to validate your database code with.
(comments are locked)
|
|
If you want to use a text files and BCP, you can simply create a view or query in which you can quote all strings and for null values simply put "NULL" without quotes in the output. So all strings will be queoted and empty string will be represented by empty queotes. NULLvalue will be represented by NULL
(comments are locked)
|
|
Hi there, You might want to give a try to Volpet's Table Diff: You can try a fully-functional copy for 30 days. Please let me know for anything. Thank you, Giammarco
(comments are locked)
|
