SQL Compare 11 can not find SQL Source Control

farinro

Hello,

I am trying to use SQL Compare 11 to auto mate the deployment of databases. When i try to run a command line step in MS build:

<Exec Command='"\mlisinvwvmrlsp1ddriveProgram Files (x86)Red GateSQL Compare 11SQLCompare.exe" /server1:"$(SrouceServer)" /database1:$(SrouceDb) /revision1:$(SvnRevision) /userName1:$(SVNUserDomain)$(SvnUsername) /server2:"$(TargetServer)" /database2:$(TargetDb) /v /sync /Report:SchemaDiffReport.html /ReportType:Interactive /Force /loglevel:verbose /Options:DisableSOCForLiveDBs'/>eSOCForLiveDBs'/>

I get this Error:

MSBuild output] Argument /reporttype has value 'Interactive'
[11:26:05][MSBuild output] Argument /force has value 'True'
[11:26:05][MSBuild output] Argument /logLevel has value 'Verbose'
[11:26:05][MSBuild output] Argument /options has value 'IgnoreMigrationScripts'
[11:26:05][MSBuild output]
[11:26:05][MSBuild output] Unexpected error: Using source controlled databases requires SQL Source Control
[11:26:05][MSBuild output] to be installed.
[11:26:05][MSBuild output] Using source controlled databases requires SQL Source Control to be installed.
[11:26:05][MSBuild output] RedGate.Shared.Utils.InvalidStateException
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.#eRzc()
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.#dRzc(Int32 #HXi)
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.#pcmb(Project #zNSb, DataSourceNumber #o9rc)
[11:26:05][MSBuild output] at RedGate.SQLCompare.CommandLine.CommandProcessor.#pcmb(Project #zNSb, DataSourceNumber #o9rc)
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.#mcmb()
[11:26:05][MSBuild output] at RedGate.SQLCompare.CommandLine.CommandProcessor.#wOr()
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.#kcmb()
[11:26:05][MSBuild output] at RedGate.SQLCompare.CommandLine.CommandProcessor.#kcmb()
[11:26:05][MSBuild output] at RedGate.SQLToolsCommandLine.CommandProcessor.Run()
[11:26:05][MSBuild output] at RedGate.SQLCompare.CommandLine.Startup.Main(String[] args)
[11:26:05][MSBuild output] C:CI_BuildAgentworkt238src_checkoutSourceDatabaseRelease.xml(5,4): error MSB3073: The command ""\mlisinvwvmrlsp1ddriveProgram Files (x86)Red GateSQL Compare 11SQLCompare.exe"

Both RedGate Components are installed under the same directory: \mlisinvwvmrlsp1ddriveProgram Files (x86)Red Gate. Any help is appreciated.

Mike U

The problem here is that SQL Source Control needs to be installed on the machine that is running the Compare executable in order for Compare to find it. You're using network paths here, which implies that Compare and Source Control aren't actually installed on the machine that is running the process.

Note that even if you could get this to work, you'd run in to licensing problems, because Compare and Source Control will both look for their licenses on the local machine.