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

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

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

Comments

1 comment

Sort by
  • Dan_J
    Hi @...

    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!
    Dan_J
    0

Add comment

Please sign in to leave a comment.