Command line error

MrsFatherjack · March 28, 2011 6:58AM

Hi, I wonder if you can help. I'm trying to execute a data compare project from a command line and I'm getting the message:

'sqldatacompare' is not recognised as an internal or external command.

The code I'm putting in the command line is:

c:\sqldatacompare /Project:"C:\Redgate\TestProject.sdc"

Any help would be gratefully received.

Thanks

peter.peart · March 28, 2011 7:35AM

Hi Annette,

Thanks for your post. Assuming you are trying to run this as part of a scheduled job (i.e. in a batch file), the code in the batch file will need to look something like:

@echo off
"C:\Program Files &#40;x86&#41;\Red Gate\SQL Data Compare 9\sqldatacompare.exe" sqldatacompare /Project:"C:\Redgate\TestProject.sdc"

So, essentially you need to ensure that you specify the install path in the file.

HTH!

Pete

MrsFatherjack · March 28, 2011 8:21AM

That's great and is working fine. My next issue is how to get it, through the batch file, to export to a CSV? Can you help with this please or should I put this as another question?

peter.peart · March 28, 2011 8:32AM

No problem:

@echo off
"C:\Program Files &#40;x86&#41;\Red Gate\SQL Data Compare 9\sqldatacompare.exe" sqldatacompare /Project:"C:\Redgate\TestProject.sdc" /export:"C:\SQLDataCompareReports\Differences.csv" /force

The /force switch overwrites any existing Differences.csv file that you have in that location. For a full list of switches available, you can CD to the install path and then run the following from the command line:

sqldatacompare /Help /Verbose /Html &gt; "C:\SQLDataCompare9_Help.html"

This should then create a file viewable in your browser of choice with a full list of switches.

HTH!

Pete

MrsFatherjack · March 28, 2011 8:34AM

Wow, that is absolutely fantastic and working perfectly. many many thanks.

peter.peart · March 28, 2011 8:35AM

You're welcome

Command line error

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk