My scenario is I have two SQL scripts that are very similar and are used to insert values into setup tables.
The only difference between the two scripts is the values that are inserted into the tables. One sript is for a staging environment and the other is for a production environemnt.
Ideally, I would like a tool that would compare the two queries and highlight any differences in the syntax.
The other thought I had was some way to run a "mock" run of the production script to a file or view without actually updating the database so I can ensure the results are correct prior to runnning.
How would you efficiently do this query comparison? I'm not sure what built-in or add-on tools are available.