Red Gate forums :: View topic - SQL Compare between branches in TFS
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare between branches in TFS

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
hil



Joined: 09 May 2014
Posts: 1

PostPosted: Fri May 09, 2014 6:18 pm    Post subject: SQL Compare between branches in TFS Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Mon May 12, 2014 11:20 am    Post subject: Reply with quote

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:

Quote:

/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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group