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