SQL Compare between branches in TFS

hil

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.

Eddie D

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