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

Data Compare - Problem with Restoring Keys

When we try to synchronize the data it fails because of referential integrity. It doesn't restore the key constraints in the proper order. Am I doing something wrong. I think your software should be able to restore the key constraints in the proper order so it doesnt fail.
dheinz
0

Comments

4 comments

Sort by
  • richardjm
    Can I ask if you are using the RC1 or the beta as there were problems with foreign key ordering in the beta? Also what options have you got set in the project?

    Thanks
    richardjm
    0
  • dheinz
    Its the Beta version. Here are the Advanced Options.

    Ignore:
    - Fill Factor
    - With NoCheck
    - FileGroups
    - Quoted Identifiers
    - User Properties
    - With Element
    dheinz
    0
  • richardjm
    Can you try using the RC1 version to see if this helps?

    Thanks
    richardjm
    0
  • richardjm
    dheinz wrote:
    Its the Beta version. Here are the Advanced Options.

    Ignore:
    - Fill Factor
    - With NoCheck
    - FileGroups
    - Quoted Identifiers
    - User Properties
    - With Element

    Just been pointed out to me (ok not had enough coffee this morning) that these are SQL Compare options not SQL Data Compare options.

    Can you confirm exactly what it is you are trying to do?
    richardjm
    0

Add comment

Please sign in to leave a comment.