A client asked for a summary of changes, so I wrote this quick post to show where to find this in SQL Compare 15.
If you use SQL Compare, you might find yourself in situations like this, where there are a bunch of changes.
This isn’t a lot, but when you build the script, you then are confronted with a lot of information. If I choose all those objects, here’s my script in the deploy wizard.
This is a lot of code to look through. Most people can do this, but it’s also easy to miss something in this long listing. Humans make mistakes, and we want to minimize mistakes.
The UX isn’t great, but if you look at the top of the code window, below the 14 objects part, there are three items: Deployment Script, Summary, and Warnings. If there are significant warnings, that will actually be the default screen, but the summary is something people miss. You can see this below:
If I click Summary, I see this:
This is a much more manageable list of things that are being touched, and a good list to show in a standup or code review for others to watch.
Grabbing a screen shot is something you could easily send to people as well. If you use the Flyway solution, we’ll also generate a report of this with your CI or deployment processes.
Give this a try the next time you use SQL Compare. If you don’t use it, give it a try. It’s amazing.