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

Sqlcompare cmdline - ignore additional&identical?

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.
mzcopea
0

Comments

4 comments

Sort by
  • 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
    Daniel Handley
    0
  • finalist
    Daniel,
    Do you know if this will be supported in a future release? I belive this would be an important addition
    finalist
    0
  • 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
    Daniel Handley
    0
  • 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
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.