What are the challenges you face when working across database platforms? Take the survey

Can you use a WHERE clause in datacompare command line

stiej1977stiej1977 Posts: 12

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.



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.