Activity overview
Latest activity by rj-guerra
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...
Automating command line tool
Hi there,
we want to automate the command line tool execution in TeamCity passing in a project file.
How can we check for the comparison execution result ?
From what i see from the documentation, t...
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...
Command line tool questions
Hi there,
is it possible to use the ".sdc" project file (generated in the GUI application) in the command line tool ?
I'm asking this because we need to perform data comparison on many tables and ...