SQL Source Control Patch - View History from within SSMS!

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

SQL Source Control Patch - View History from within SSMS!

Postby sherr » Wed Aug 18, 2010 4:23 pm

As of September 28th 2010, these fixes are now available in the latest release. Details are at :
http://www.red-gate.com/MessageBoard/vi ... hp?t=11572

Patch to SQL Source Control v1.0.6.3 - Released 18 August 2010
================================================

This is the latest cumulative patch for SQL Source Control. This patch contains 2 new features:
View the database’s history from the Object Explorer context menu so you can see who changed what, when, and why
TFS Users – associate your commit to Work Items through the commit comments (see our forum for details)
(SVN Users – if your SVN is configured for bug integration with other tools, then typing the Bug ID into the commit comments should already work)

This patch also addresses the following issues found with the tool:
• SOC-1369 Input string error, if linking a non-empty db to an existing repo that contains curly braces ({ or })
• SOC-1370 We now support the DATA COMPRESSION 2008 keyword
• SOC-1023 We now support 64 bit assemblies
• and more...
Last edited by sherr on Wed Sep 29, 2010 3:11 pm, edited 1 time in total.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

View history in SSMS for an object

Postby fsvard » Thu Sep 09, 2010 10:20 am

Hi,

When clicking the new history option the window that comes up contains all changes to the database not the selected object.

Is this something you can add so that we can view the history per object?

We use TFS 2010, SSMS 2010 R2 and sql source control 1.0.6.3.

Regards
Fredrik
fsvard
 
Posts: 1
Joined: Thu Sep 09, 2010 10:17 am

Re: View history in SSMS for an object

Postby David Atkinson » Thu Sep 09, 2010 2:17 pm

fsvard wrote:Hi,

When clicking the new history option the window that comes up contains all changes to the database not the selected object.

Is this something you can add so that we can view the history per object?

We use TFS 2010, SSMS 2010 R2 and sql source control 1.0.6.3.

Regards
Fredrik


The next early access release will have this fix. And it will also let you revert to a historical version (you will need SQL Compare Pro installed to do this).

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re: View history in SSMS for an object

Postby MH » Mon Sep 13, 2010 4:21 pm

David Atkinson wrote:The next early access release will have this fix. And it will also let you revert to a historical version (you will need SQL Compare Pro installed to do this).

David Atkinson
Red Gate Software


What is a "source control" software good for, if you can't revert to a historical version (without purchasing another product)? :-(
SQL Source Control 1.0.6.3;SQL Server Managament Studio 10.0.2531.0
MH
 
Posts: 2
Joined: Mon Sep 13, 2010 4:10 pm

Postby David Atkinson » Mon Sep 13, 2010 5:00 pm

Red Gate's offering is a collection of tools that can be used individually and/or in combination with each other. SQL Compare Pro has always been Red Gate's deployment tool, whether or not the source and targets are historical source-controlled databases, live databases, or even Backups.

SQL Source Control on its own can achieve a lot, such as user collaboration, auditing, compliance and versioning. SQL Source Control can undo the last change you made assuming it hasn't yet been committed to source control yet. Without SQL Compare Pro you can still in theory view the history, and it's not difficult to restore an old stored procedure to your database, for example. It's only if you want to do more advanced recovery from a previous version that you need SQL Compare for.

We recommend that to have a full solution the SQL Developer Bundle be purchased, which gives you not only SQL Source Control but the pro versions of the other developer tools.

Regards,

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Object Level History

Postby sherr » Wed Sep 29, 2010 3:12 pm

In the v1.1 release, history is now available at the database level and object level depending on where you right-click in the Object Explorer. For full details, see http://www.red-gate.com/MessageBoard/vi ... hp?t=11572.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron