How can we help you today? How can we help you today?

Can you use a WHERE clause in datacompare command line

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
stiej1977
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.