SQL Data Compare Command Line - include a Where clause

JimEdgeton

Hello, we are attempting to automate some RedGate comparisons through the command line functionality. However, we do not see a command line option to include a "where" clause like the RedGate GUI offers to do on particular tables.

Does the command line support "where" clauses on compared tables? And if yes, what is the syntax or documentation for that?

Thank you!

Sarah B

Hi @JimEdgeton

Thanks for your post.

Unfortunately, no, the command line doesn't support "where" clauses on compared tables.

You could use the GUI to create a project and save it.  Then in the cmd line use /project switch.

JimEdgeton

@Sarah B Thank you for helpful suggestion - that approach should solve my immediate issue. If there's an opportunity for a command line enhancement someday in the future, supporting "where" clauses is something I would request considering. Thank you again, Sarah!

nmwael

Sarah B said:

Hi @JimEdgeton

Thanks for your post.

Unfortunately, no, the command line doesn't support "where" clauses on compared tables.

You could use the GUI to create a project and save it.  Then in the cmd line use /project switch.

Are there any plans to implement this?