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

Command line where clause

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?

Thanks
si_he
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi,

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

Add comment

Please sign in to leave a comment.