SQL Compare 11 can not find SQL Source Control
farinro
Posts: 2
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.
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.
Comments
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.
Redgate Software