Sqlcompare cmdline - ignore additional&identical?

mzcopea

I am using SqlCompare to compare my database with a snapshot. I want to output the differences to a sql script to apply to the db later, but I want it to ignore Additional and Identical. I will not be synchronizing through Sqlcompare.

I can turn off Identical and Additional in the GUI Sqlcompare tool.

But the commandline options /ignoreidentical and /ignoreadditional appear only to be available to SqlDATACompare.

Is it possible to do this with SqlCompare command-line options?

Thanks.

Daniel Handley

Hi

As you have found out, in the GUI you can click on the arrow icons to filter changes on missing, additional, and different.

This functionality is currently unavailable in the command line options for SQL Compare.

Regards
Dan

finalist

Daniel,
Do you know if this will be supported in a future release? I belive this would be an important addition

Daniel Handley

Hi

This is on the wish list for the next command line tools, but the timetable for development has not yet been finalised.

Once we know how long we have to develop the tools we can work on what feature will be included.

Regards
Dan

Brian Donahue

Hello there,

If you are simply exporting the SQL schema script, there should be no action for identical objects. If you're concerned about keeping equal objects out of the report that sqlcompare produces, then maybe this earlier post may be of interest to you:

http://www.red-gate.com/messageboard/vi ... php?t=1122