Comments
Sort by recent activity
OK Brian, how can I do a checksum comparison ? / comments
OK Brian, how can I do a checksum comparison ?
Hi Brian, thanks for your reply.
What we're trying to achieve is to integrate data comparison with our automated test process.
We need to write an integration test that calls a feature on our system that changes multiple database tables.
Since asserting multiple conditions is not feasible for this scenario we see that SQL Data Compare integration would be handy.
For that matter, instead of calling multiple asserts, we would run the command-line tool and pass the ".sdc" project file.
Then, we need to check the the tool return code and assert whether the comparison indicates the compared tables are identical or not.
If they are identical it means that the feature is running as expected, if not, the test fails.
Running the command line tool from within the test is fairly simple, i just need to capture the return code then.
The command i think can accomplish this is the following:
SQLDataCompare.exe /project:"data-comparison.sdc" /Include:Identical
So you see this is achievable ?
Thanks!
Ricardo / comments
Hi Brian, thanks for your reply.
What we're trying to achieve is to integrate data comparison with our automated test process.
We need to write an integration test that calls a feature on our syste...
OK i just read the "http://documentation.red-gate.com/display/SC103/Simple+examples+using+the+command+line"
which indicates we can use the project file as:
sqlcompare /project:"C:\SQLCompare\Projects\Widgets.scp"
Thanks a lot / comments
OK i just read the "http://documentation.red-gate.com/display/SC103/Simple+examples+using+the+command+line"
which indicates we can use the project file as:
sqlcompare /project:"C:\SQLCompare\P...