- Code: Select all
"C:\\Program Files (x86)\\Red Gate\\SQL Compare 10\\sqlcompare.exe" /sourcecontrol1 /revision1:HEAD /s2:MyDatabaseServer /db2:MyDatabaseName /o:Default /Include:identical /sfx:Automated.xml /sync
Automated.xml was located in the directory that I ran the command line from. I tried this again on my build server using the exact same command and got the following error:
Error: The file 'Automated.xml' containing the script folder location XML fragment could not be parsed. Check that the file exists and that its contents are well-formed.
My build server has both SQL Compare and SQL Source Control installed and they are both in the same version as on my workstation. The Automated.xml is also located in the directory where I am calling the the command line from on the build server.
I should also note that SQL command line normally does work on my build server. It just only give me this error when I'm trying to read from an XML file to get the script file location in source control (which is what I want to do here).
Why is my workstation running the command prompt without errors, but the exact same command is giving me error on my build machine? Does my build machine need something installed or setup in order to make it work?