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

ignoring foreign key constraints

hi - i would like to ignore foreign key constraints in my "new" database so they are not generated into the script i'm creating.

i can't see which difference to ignore, or what option on the work to generate.

thanks,
chris
chrismcv
0

Comments

4 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    Are you refering to sycnhronizing the schema or the data?

    If you are perfroming a schema synchronisation using SQL Compare, you can use the option 'Ignore Foreign Keys' which means that the script will not sync the foreign keys.

    If you are using SQL Data Compare for a Data sync' then SQL Data compare will detect the foreign keys on the target databse and give you the oportuntity to disable them for the purposes sync.

    Can you give me an example of what you think shouldn't be happening?
    Chris Auckland
    0
  • chrismcv
    hi chris - i meant to post in the SDK section. this is for a schema migration, and I cannot find an IgnoreForeignKeys option in there.
    thanks,
    chris
    chrismcv
    0
  • Chris Auckland
    Oh ok, no problem.

    The option your're looking for is:

    Options.IgnoreKeys
    Chris Auckland
    0
  • chrismcv
    splendid, thanks
    chrismcv
    0

Add comment

Please sign in to leave a comment.