SQL Source Control Patch - View History from within SSMS!

[sherr]

As of September 28th 2010, these fixes are now available in the latest release. Details are at :
http://www.red-gate.com/MessageBoard/viewtopic.php?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...
_________________
Thank you!
Stephanie M. Herr
SQL Tools Development Manager

[fsvard]

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

[David Atkinson]

[MH]

[David Atkinson]

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

[sherr]

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/viewtopic.php?t=11572.
_________________
Thank you!
Stephanie M. Herr
SQL Tools Development Manager

[Aries86]

Thanx for sharing it.
_________________
Aries86