How to specify WHERE Clause filter in commandline interface?

Al C

I have a WHERE clause filter in my SQLDataCompare. I want to automate the DataCompare using the commandline options. I have it set up except for the WHERE clause. How do I incorporate it into the commandline?

Brian Donahue

Hi Al,

Unfortunately this facvility isn't available for the command line. What you need to do is create a project and run a comparison with a WHERE clause, then right-click the project settings that you had just created and select 'locate on disk'. Next, copy the project file to your command-line directory and instruct SQLDATACOMPARE.exe to run this project file rather than specifying all of the arguments explicitly on the command line using the /pr: argument.