locked
Sync Framework - Not bringing over Foreign Keys? RRS feed

  • Question

  • Hi All,

    I am using Microsoft Sync Framework, and it is bringing over my tables, but it is not pulling over the Foreign Keys? I have made sure that the parent (PK Table) is being brought over first as I would assume that would cause the FKs to fail.

    What am I missing here that is not allowing the FKs to be brought with the sync?

    Using SQL Server 2008 R2 and SQL Server 2008 R2 Express. Visual Studio 2010 and I believe Sync Framework 2.1?

    Any suggestions would be greatly appreciated.

    Thanks,

    B

    Tuesday, April 5, 2011 8:49 PM

Answers

  • Sync Fx doesnt provision FKs and other constraints other than the PK. you will have to script out your FKs and apply them programmatically.

    Tuesday, April 5, 2011 11:36 PM