What are the challenges you face when working across database platforms? Take the survey

SQL Compare Options

jkeiljkeil Posts: 7
edited November 3, 2008 7:48AM in SQL Compare Previous Versions
I have a case where I want to create an update script that is only for objects found in the source db and are missing in the target db. I am using the XML config file for the command line options, but can't get these to work.... /ignoreidentical, /ignoredifferent, /ignoremissing, /ignoreadditional. Are these options not available from within the XML? If not, how can you provide a selection on the type of statements you want to allow like only "creates" or only "alters"?

I also noticed that in the GUI if you leave only the "missing in target" option...you don't get that filter in the Synchronized generated script.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    The syntax for switches in XML is <switch>value</switch>, so you should specify, for example <ignoreidentical>yes</ignoreidentical>
  • Options
    I can't seem to get /ignoremissing to work at all via the command line.

    I also can't seem to find it documented anywhere.

    The syntax


    does not work at all

  • Options
    The reason you can't find it documented anywhere is that it's actually a SQL Data Compare option, not a SQL Compare option - the original post appears to have been put in the wrong forum.

    Sorry for the confusion.
    Software Developer
    Redgate Software
Sign In or Register to comment.