Activity overview
Latest activity by Xaphan
Force migration script use with SQLCompare.exe
I'm using SQLCompare.exe to do automated deployments from my source control to my test environment. When a deployment occurs I noticed that migration scripts that I have stored in my source contro...
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.
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...
Filter static data but not the table scheme
Is there a way I can have SQL compare filter out certain tables for static data, but still compare the table scheme? For example, let's say my source control has tables A, B, and C and they all ha...
This is exactly what I needed. Thanks! / comments
This is exactly what I needed. Thanks!
Deploying Static Data With SQL Compare Command Line
I'm using SQL Compare in my CI process to deploy databases to my test server. The CI server calls the SQL Compare command line in order to do this. Compare deploys the database schema just fine, b...
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
SQL Compare command line not working on build machine
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:H...
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...