Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
One-off sync to sql express database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a requirement where I need a database to be provisioned on the clients SQL Server Express database from a SQL Server database. I've defined a filtered scope containing the tables/data I need which is all fine and the sync works, however for my particular requirement its basically a one-off synchronization per client requirement - once the initial provision and sync has been done to a client I never need to incrementally get changes again. Is this kind of scenario supported? I dont really need all the triggers and tracking tables since Im not interested in tracking changes, only in the initial database populate. Any help would be appreciated.

     

    Thanks very much!

     


    Monday, May 23, 2011 3:14 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    just DeprovisionStore after the initial sync to remove all Sync Fx related objects.

    you can also do this using the offline provider, just set the sync direction to Snapshot only.

    • Marked as answer by Mark Dakers Monday, May 23, 2011 6:44 AM
    Monday, May 23, 2011 5:29 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    just DeprovisionStore after the initial sync to remove all Sync Fx related objects.

    you can also do this using the offline provider, just set the sync direction to Snapshot only.

    • Marked as answer by Mark Dakers Monday, May 23, 2011 6:44 AM
    Monday, May 23, 2011 5:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks June, I assume the snapshot will work correctly with a filtered scope?
    Monday, May 23, 2011 6:18 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    snapshots are in the older providers (SqlCeClientSyncProvider/DbServerSyncProvider) where you define a sync group.

    if you're using filtered scope on SqlCeSyncProvider/SqlSyncProvider, you'll have to do the provision/deprovision path.

     

    hth,

    junet

    Monday, May 23, 2011 8:19 AM