Evaluate the potential use of a WHERE clause in SQL data queries to compare records within the table

ajwad

How can I modify the script below to copy only the data from the 'cars' table in the 'TEST' database where active = 1?

/s1:source1 /db1:TEST /s2:source2 /db2:TEST /loglevel:Verbose /Sync /Include:table /Include:table /Include:Different /Include:Missing /Include:Identical 

Dan_J

Hi @ajwad

Thanks for reaching out to us regarding this.

Unfortunately you cannot utilize a WHERE clause when using the /s1:source1 /db1:TEST /s2:source2 /db2:TEST switches. In order to use one you will need to first create a project using the SQL Data Compare GUI where you can configure the WHERE clause. Then, using the CLI, you will need to replace the /s1:source1 /db1:TEST /s2:source2 /db2:TEST switches with /project:"<path to the project file.sdc>". 

This is also mentioned in our documentation: https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line 

I hope this helps!