SyncAgent snaphsot and missing FK RRS feed

  • Question

  • Hello!

       According to the suggestion from this forum, I am using SyncAgent to make a DB snapshot. So, if I do it, created snapshot doesn't contain FKs. SyncTable instances I am creating by this way:

    for (int i = 0; i < tableNames.Length; i++)
      SyncTable table = new SyncTable(tableNames[i]);
      table.CreationOption = TableCreationOption.DropExistingOrCreateNewTable;
      table.SyncDirection = SyncDirection.Bidirectional;

      tables[i] = table;

       I would like to notice, that before synchronization empty result table with all FKs exists already. Is it standard behavior (missed FKs) or I am doing something wrong?



    Thursday, May 9, 2013 7:31 AM

All replies

  • I can answer by myself...

    SyncTable.SyncTable must be different than TableCreationOption.DropExistingOrCreateNewTable (e.g. TableCreationOption.TruncateExistingOrCreateNewTable).

    So, there was also a little mistake in SyncDirection (should be Snapshot).

    Thursday, May 9, 2013 8:04 AM