How to specify WHERE Clause filter in commandline interface?

Al CAl C Posts: 12
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?
Thanks, Al


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.