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

Exporting list of changes to commit to a text file

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

Comments

6 comments

Sort by
  • Victoria W
    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 

    Victoria W
    0
  • David Atkinson
    @MarkRoberts1964 - do your developers use a single shared development database, or do they each have their own dedicated database?

    David Atkinson
    0
  • MarkRoberts1964
    @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
    0
  • MarkRoberts1964
    @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.
    MarkRoberts1964
    0
  • DanC
    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
    DanC
    0
  • MarkRoberts1964
    Thanks for following up @DanC.
    MarkRoberts1964
    0

Add comment

Please sign in to leave a comment.