What are the challenges you face when working across database platforms? Take the survey

Reporting options for DB Changes

pvanhousepvanhouse Posts: 9 Bronze 1
We are using Redgate SQL Source Control with SVN as our source control repository.

Is there a way to generate change reports that will show the database name, object name, Date of Change, type of Change, and user who made the change?

We have to run a monthly report documenting changes to specific objects (such as SP's, functions, triggers) as well as some static data that store system options. We are currently running several procedures to get the data we need and were hoping Source Control would ease our reporting process.

The tools within RG Source Control are great, especially troubleshooting issues with new procedures, but I don't see any obvious reporting tools that can generate the data we need with either RG or SVN.
Paul Van House


  • Options
    That's a great question. It's really a Subversion question, rather than a SQL Source Control question.

    If you use TortoiseSVN, it's possible to select items from the list of changes in the Log (right click on your database Scripts Folder, and choose Show Log. From this dialog do Ctrl-C for copy, and then paste it as text into a document. It's not particularly pretty, but it does have the information you specified.

    My advice would be for you to post the same question on StackOverflow, as you'll benefit from the experience of thousands of expert Subversion users.

    Kind regards,

    David Atkinson
    Red Gate
    David Atkinson
    Product Manager
    Redgate Software
Sign In or Register to comment.