How can we help you today? How can we help you today?

Compare the results of two queries

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
Ballinhuge
0

Comments

3 comments

Sort by
  • 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,

    AlessandroAlpi
    0
  • AlexYates
    SQL Data Compare command line documentation:

    https://documentation.red-gate.com/display/SDC12/Using+the+command+line
    AlexYates
    0
  • 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.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.