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

Setting SqlOptions

Hi,

I'm using SqlDataCompare to compare 2 databases, and need to set the DisableTriggers option to true.
I guess I can set the option through SqlProvider.options, but can't get this working, could someone provide a c# code sample?

many thanks,

Adam
adamtyson
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello Adam,

    Certainly! You can specify options to the SqlProvider like this: 
    SqlProvider p=new SqlProvider();
p.Options=SqlOptions.Default | SqlOptions.ExcludeIdentities | SqlOptions.TrimTrailingSpaces;
    or this: 
    SqlProvider p=new SqlProvider();
SqlOptions enOptions=SqlOptions.Default | SqlOptions.ExcludeIdentities | SqlOptions.TrimTrailingSpaces;
p.Options=enOptions;
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.