Options

SQL Compare between branches in TFS

hilhil Posts: 2
edited May 12, 2014 6:20AM in SQL Compare Previous Versions
Is it possible to compare two branches in TFS 2012 Source Control with the commandline version of SQL COMPARE? I know it works in the SQL Compare GUI but I had no luck with the command line version.
· Share on Twitter

Comments

  • Options
    Eddie DEddie D Posts: 1,780 Rose Gold 5
    Thank you for your forum post and sorry that you have encountered a problem.

    Yes it should be possible to compare two branches in TFS using the commandline, providing both data sources are linked using SQL Source Control. Below is the information copied from the help file:
    /Revision1:<revision>

    Alias: /r1

    Specifies the source control revision of the source database. To specify a revision, the database must be linked to SQL Source Control. To specify the latest version, type: HEAD

    Specifying a revision other than HEAD is only supported with TFS, SVN and Vault. If you're using another source control system, we recommend checking the revision out to a local folder and using the /Scripts1 switch.

    The following example compares revision 3 of WidgetStaging with the latest revision of WidgetProduction:

    sqlcompare /db1:WidgetStaging /revision1:3 /db2:WidgetProduction /revision2:HEAD

    /Revision2:<revision>

    Alias: /r2

    Specifies the source control revision of the target database. To specify a revision, the database must be linked to SQL Source Control.
    Can you please reply with the syntax you are using and further details of the error or problem you are experiencing?

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.