Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SyncAgent snaphsot and missing FK RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

       Thanks.

            Radim

    Thursday, May 9, 2013 7:31 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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