Exporting list of changes to commit to a text file

MarkRoberts1964 · December 20, 2021 9:04PM

Is there any way to export the list of changes to commit so that we can email that list to the Dev team? We are just doing manual commits right now and some developers are forgetting to commit their changes. We would like a way to export the list so we can email the dev team and remind them to do their commits. The question after that is - is there anyway to automate that process so an email comes out weekly/daily? Thanks!

Mark

Victoria W · December 22, 2021 9:22AM

Hi @MarkRoberts1964

Using SQL Compare Pro you can compare the DB to Source Control before committing and generate a Comparison Results Report:

https://documentation.red-gate.com/sc14/reviewing-the-comparison-results/generating-a-report

You should find all the information you need on automation here:

https://documentation.red-gate.com/sc/using-the-command-line

David Atkinson · December 22, 2021 3:42PM

@MarkRoberts1964 - do your developers use a single shared development database, or do they each have their own dedicated database?

MarkRoberts1964 · December 22, 2021 6:47PM

@David Atkinson We use a single shared development database. Also, I forgot to mention that we link to a Subversion repository. One last thing, we have 10 databases all linked so developers have to remember which databases they made changes in. We would like a way to export a list of changes for all databases if possible. Thanks!

MarkRoberts1964 · December 22, 2021 9:46PM

@Victoria W Thanks for your response. I ran a couple of reports and am able to see the changes not committed yet. I haven't tried the command line yet, but it seems like that would help automate the process. The one issue that I see is that the report doesn't list the person who made the change. Is that listed anywhere on the report or is there a way to include it? When a developer runs SQL Source Control within SSMS, it lists the changes and the "Last changed by" user. That would be the final piece needed I think. Thanks again.

DanC · December 30, 2021 11:04AM

Hi @MarkRoberts1964

Unfortunately, that functionality is exclusive to SQL Source Control and can't be captured using SQL Compare.

We also don't have a method of comparing multiple databases at a single time for one report and this would have to be done individually.

If you'd like to see these kinds of features I would advise posting the suggestion on the UserVoice forum here: https://redgate.uservoice.com/forums/141379-sql-compare

MarkRoberts1964 · December 31, 2021 4:42AM

Thanks for following up @DanC.

Exporting list of changes to commit to a text file

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk