SQL Source Control Patch - View History from within SSMS!

StephanieHerrStephanieHerr Posts: 176 Gold 1
edited September 29, 2010 10:12AM in SQL Source Control Previous Versions
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...
Thank you!
Stephanie M. Herr    :-)
Product Manager Database DevOps

Comments

  • 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 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
    Product Manager
    Redgate Software
  • 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
  • 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
    Product Manager
    Redgate Software
  • 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    :-)
    Product Manager Database DevOps
Sign In or Register to comment.