Command line where clause

si_hesi_he Posts: 25
I need to schedule regular data compare jobs, but I need to use a WHERE clause. Is there any way to specify a WHERE clause using the command line tool? or is the API the only way of doing this?



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    As it stands, the WHERE clause isn't supported in command-line SQL Data Compare. It is available through the API, as you've pointed out.
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    There is a workaround for this: Create a comparison project in SQL Data Compare containing the databases you want to compare and any table mappings and WHERE clause, then right-click it, select 'locate on disk', and make a copy of the project file in another location on disk.

    Next, use SQLDataCompare.exe to run the project using the /pr argument. The command-line version of SQL Data Compare can use the where clause that you'd set in the project.
Sign In or Register to comment.