Red Gate forums :: View topic - Reporting options for DB Changes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Reporting options for DB Changes

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
pvanhouse



Joined: 15 Jan 2014
Posts: 6

PostPosted: Mon Jan 20, 2014 9:21 pm    Post subject: Reporting options for DB Changes Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Tue Jan 21, 2014 11:34 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group