Can you use a WHERE clause in datacompare command line

stiej1977

Hi,

Is it possible to use WHERE clauses when using the command line version of data compare?

And how is this done exactly? Especially for a compare that involves multiple tables.

Thanks

Brian Donahue

Thanks for asking. There is no command-line argument for a WHERE clause in SQL Data Compare, however, there is a way to do this. If you create a project using the UI version of SQL Data Compare, then you can run it from the command line using the /pr:<filename> argument. The command-line version of Data Compare will respect all of the table mappings and WHERE clauses set in your project.