SQL Compare and Perforce with revision switch

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 and Perforce with revision switch

Postby Bernard » Tue Jan 21, 2014 2:56 pm

Hi, We switch from Vault to Perforce (P4V), originally this script work fine with Vault, since we are on Perforce we have this error message :

Error : Only head revisions are available for command-line base source control systems

We try to compare two database, here is the script :

"C:\\Program Files (x86)\\Red Gate\\SQL Compare 10\\sqlcompare.exe" /s1:PROD /db1:CurrentDev /r1:1287924 /s2:PROD /db2:empty /Options:iu,Default,DoNotOutputCommentHeader,IgnoreWhiteSpace /Force /sf:"C:\\OUT.SQL"

Is there a special configuration to setup SQL Compare with Perforce for supporting the compare option with a revision number?

fyi : when I replace r1:1287924 by r1:HEAD it work fine.

Thanks,

Bernard
Bernard
 
Posts: 1
Joined: Tue Jan 21, 2014 2:21 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: Google [Bot] and 0 guests