Joined: 14 Jun 2006
Location: Red Gate Software
|Posted: Mon May 12, 2014 11:20 am Post subject:
|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:
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
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?
Technical Support Engineer
Red Gate Software Ltd