I know that SQL Compare has the option to generate an interactive report as see here:https://documentation.red-gate.com/sc10/reviewing-the-comparison-results/generating-a-report
and the command line options here: https://www.red-gate.com/hub/product-learning/sql-compare/sql-compare-command-line (scroll to "Generate a report outlinging the changes".
I'm wondering if something similar is available to ReadyRoll.
I ask because, before a live release we have a process where the SQL script being run on the live environment is given a final once over and to view the changes, we have to:
- Download the package from Octopus
- Check which mirgation ids have already been run on live (select from migration table)
- Find all the migration id's in the package downloaded from Ocotpus and use this to view what will be execute
Is this at all possible?