Reporting options for DB Changes
pvanhouse
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.
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
Comments
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
Product Manager
Redgate Software