How can we help you today? How can we help you today?

Using SQL Compare from the command line help

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
gsuttie
0

Comments

1 comment

Sort by
  • 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.
    James B
    0

Add comment

Please sign in to leave a comment.