Reporting options for DB Changes

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Reporting options for DB Changes

Postby pvanhouse » Mon Jan 20, 2014 9:21 pm

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
pvanhouse
 
Posts: 6
Joined: Wed Jan 15, 2014 8:29 pm

Postby David Atkinson » Tue Jan 21, 2014 11:34 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest