Compare the results of two queries

Ballinhuge

Hello, I am new to RedGate software and I am looking for a way to automate a process. Is it possible to use SQL Data Compare to compare the results of two queries? One on the production and another on the development. After the comparison I would like to be able to move the development changes to production and generate a report of a change for auditing purposes. All this I would like to be to able to do from a command line. If this is possible can someone point me in the right direction on where the documentation is on how to accomplish this task?

Thank you

AlessandroAlpi

Hi @Ballinhuge,
if you go to the project properties, you can specify only the where filter for comparing data (and also the columns to be considered). The comparison process should be made between objects, not queries. If you mean different Where conditions, you can (as described before) but otherwise, I guess you should compare the queries manually.
About the automation, the tool creates a deploy script and preview the differences for you, but when you compare objects.
Please, let me know if I got it correctly.

ciao,

AlexYates

SQL Data Compare command line documentation:

https://documentation.red-gate.com/display/SDC12/Using+the+command+line

sam.blackburn

If you need more flexibility than is provided by a WHERE clause, you could always create views containing your queries and compare those.