SQL Compare between branches in TFS

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Compare between branches in TFS

Postby hil » Fri May 09, 2014 6:18 pm

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.
hil
 
Posts: 1
Joined: Fri May 09, 2014 6:15 pm

Postby eddie davis » Mon May 12, 2014 11:20 am

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest