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

SQL Compare Options

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

Comments

3 comments

Sort by
  • Brian Donahue
    The syntax for switches in XML is <switch>value</switch>, so you should specify, for example <ignoreidentical>yes</ignoreidentical>
    Brian Donahue
    0
  • 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!
    austrianfoodispuke
    0
  • 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.
    Michelle T
    0

Add comment

Please sign in to leave a comment.