SQL Compare Options

jkeil

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.

Brian Donahue

The syntax for switches in XML is <switch>value</switch>, so you should specify, for example <ignoreidentical>yes</ignoreidentical>

austrianfoodispuke

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


/options:IgnoreMissing


does not work at all

Help!

Michelle T

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.