Comments
Sort by recent activity
SQL Compare will compare data if it is static data, which is data that can be stored in source control. I have done this before by using the /Include:StaticData argument in the SQL Compare command line and I have confirmed that this does work. The question that I have is how can I compare tables without the static data only for certain tables? / comments
SQL Compare will compare data if it is static data, which is data that can be stored in source control. I have done this before by using the /Include:StaticData argument in the SQL Compare command...
This is exactly what I needed. Thanks! / comments
This is exactly what I needed. Thanks!
Red Gate's staff helped me fix this. It turned out that SQL Source Control had to be re-installed on the build machine. After I did that everything worked like a charm. / comments
Red Gate's staff helped me fix this. It turned out that SQL Source Control had to be re-installed on the build machine. After I did that everything worked like a charm.
I have confirmed that the XML is the exactly the same on both machines. Here is the contents of the XML file (I changed the names of the actual servers since this is a public forum): <?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="TfsLocation">
<ServerUrl>http://MyTFSServer:8080/tfs/MyCollection/</ServerUrl>
<SourceControlFolder>$/MyDatabase/Automated</SourceControlFolder>
</ISOCCompareLocation>
/ comments
I have confirmed that the XML is the exactly the same on both machines. Here is the contents of the XML file (I changed the names of the actual servers since this is a public forum):<?xml versi...
I realized that this ticket was closed before I posted my last response. I have re-posted the response as a new issue to... http://www.red-gate.com/MessageBoard/viewtopic.php?p=61215#61215 / comments
I realized that this ticket was closed before I posted my last response. I have re-posted the response as a new issue to...http://www.red-gate.com/MessageBoard/viewtopic.php?p=61215#61215
Thanks for the reply. I looked in to this issue further and here is what I found... I was able to get SQL Compare to work with the following command line on my personal workstation: "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 the same version as on my workstation. They also are located in the same directory. The Automated.xml is also located in the directory where I am calling the the command line from on the build server.
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? / comments
Thanks for the reply. I looked in to this issue further and here is what I found... I was able to get SQL Compare to work with the following command line on my personal workstation:"C:\Program Fil...