none
Client provisioning problem with the FK relationships using the candidate keys as their parent columns RRS feed

  • Question

  • Hi, everybody

    I am developing the sync application which syncs the Sql Express client and Sql Server.

    Bu I have a problem when applying the FK constraints.

    Some FK constraints use the candidate key as a parent column.

    I got an error when provisioning the client database.

    Error is occurred there are no primary or candidate keys in the referenced table "XX" tat match the referencing column list in the foreign key "YYY".

    How can I apply to the client a candidate key? (applying the fk relationship using candidate key )

    Will appreciate any help from you.

    Thanks for your attention.

    Best Regards

     

    Wednesday, January 26, 2011 2:46 AM

Answers

  • FK and other constraints expcet the primary are not automatically provisioned by the syncFx. you will to ensure the all tables to be created and the primary keys are set correctly. then apply the script to create foreign keys.

    thanks

    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, January 26, 2011 8:39 PM
    Moderator