locked
Regarding Finding whether schema changes are done in DB Sync RRS feed

  • Question

  • When doing a DB Sync, the very first time the SyncFramework does a schema download and not a DB Sync.

    Is there a way to find out whether we have downloaded (synced) schema OR we have done a DB Sync (with rows downloaded uploaded).

     

    Thanks,

    Regards,

    Lalit.


    Novice
    Monday, July 11, 2011 12:00 PM

Answers

  • Sync Framework doesnt do schema syncs. the provisioning of Sync framework database components in SqlCeClientSyncProvider is dictated by the tables's CreationOption (CreateNewTableOrFail, UseExistingTableOrFail, etc...).

    you can subscribe to the CreatingSchema or SchemaCreated events if you want to know if Sync framework is provisioning the tables.

    • Marked as answer by LalitSRana Thursday, July 14, 2011 6:11 AM
    Monday, July 11, 2011 2:20 PM

All replies

  • which provider are you using?
    Monday, July 11, 2011 12:16 PM
  • Please let us know what you mean by provider you are using? We are using the WCF service and using a remote and the local provider provided by the framework.

    When we are synching first time we are getting the following two columns created

    _sysChangeTxBsn bigint
    _sysInsertTxBsn bigint

    This doesn't do synchronize, only adds these two columns. Synchronization doesn't fail it updates the table schema (adding the two columns).

     


    Novice
    Monday, July 11, 2011 12:49 PM
  • Sync Fx has two kinds providers... are you using SqlCeSyncProvider/SqlSyncProvider or SqlCeClientSyncProvider/DbServerSyncProvider? did you use the Local Database Cache Wizard?

     

    Monday, July 11, 2011 1:01 PM
  • No Local Database Cache wizard was not used..We used Netcfsvc to generate the client files..we have used

    SqlCeClientSyncProvider


    Novice
    Monday, July 11, 2011 1:24 PM
  • Sync Framework doesnt do schema syncs. the provisioning of Sync framework database components in SqlCeClientSyncProvider is dictated by the tables's CreationOption (CreateNewTableOrFail, UseExistingTableOrFail, etc...).

    you can subscribe to the CreatingSchema or SchemaCreated events if you want to know if Sync framework is provisioning the tables.

    • Marked as answer by LalitSRana Thursday, July 14, 2011 6:11 AM
    Monday, July 11, 2011 2:20 PM