Using SQL Compare from the command line help

gsuttie

Hi There

I need some help to compare the scripts folder with a database on our server from a batch file running on my local pc.

So far I have this:-

cd "C:\Program Files\Red Gate\SQL Compare 8" sqlcompare.exe /scr1:"C:\SVNWORK\<projetc name>\trunk\Database"

/server:<server name>\SQL2005 /db2:Quartet200 /o:Default /Report:"C:\SchemaDiffReport.html" /ReportType:Interactive
/ScriptFile:"C:\SchemaSyncScript.sql" /sync

James B

Thanks for your post. I've contacted you directly to look at it in detail, but I think the main issues will be you don't need to "cd" if you have the full path, and you should enclose "sqlcompare.exe" in the quotes too.
Also, you should specify the server as /server2 so it knows which "side" of the comparison it relates to.