none
Research questions on using Sync Fx RRS feed

  • Question

  • Hello all, we are looking to implement sync functionality for a suite of apps we are releasing later this year.  Basically these apps work remotely offline and we want to sync the remote db back to the corporate db.  So we are trying to decide if the Sync Framework is our best approach.  The apps are built using VS 2010/4.0 and the corporate db is Sql Server 2008 and the local db's will be Sql Server 2008 Express.

    So can Sync Framework meet the goals listed below - thanks for your input!

    Goals

    1. Sync can occur between Sql Server 2008 Enterprise and Sql Server Express databases
    2. Sync can be implemented without requiring IIS, WCF, etc. - network admin is hesitant about implementing web servers, etc. so its preferred that all we need is a VPN connection between the remote laptop and the corporate db
    3. Sync Fx can be used to initially deploy the remote db file
    4. Sync Fx can update remote db schema to match corporate db schema
    5. Sync master table data from corporate db to local db
    6. Sync select group of transactional table data from local db back to corporate db (multiple apps may use the remote db so each app is looking to sync only those transactional tables that it interacts with - not all transactional tables)
    Thursday, September 23, 2010 5:36 PM

Answers

  •  

    1. Sync can occur between Sql Server 2008 Enterprise and Sql Server Express databases  - YES
    2. Sync can be implemented without requiring IIS, WCF, etc. - network admin is hesitant about implementing web servers, etc. so its preferred that all we need is a VPN connection between the remote laptop and the corporate db - YES, for as long you can connect to the database servers
    3. Sync Fx can be used to initially deploy the remote db file - YES, you can generate a SQL CE SDF file using GenerateSnapshot to initialize other databases/replicas.  
    4. Sync Fx can update remote db schema to match corporate db schema - NO, Sync Fx doesnt automatically handle schema changes, you will have to write some code to handle this.
    5. Sync master table data from corporate db to local db -YES, you can configure sync Download Only, Upload Only or Bidirectional
    6. Sync select group of transactional table data from local db back to corporate db (multiple apps may use the remote db so each app is looking to sync only those transactional tables that it interacts with - not all transactional tables) - YES, you can define SyncGroups or Scopes to specify which columns/tables to sync and also specify filters on these tables.
    • Marked as answer by Bo416 Friday, September 24, 2010 6:44 AM
    Thursday, September 23, 2010 11:51 PM
    Moderator

All replies

  •  

    1. Sync can occur between Sql Server 2008 Enterprise and Sql Server Express databases  - YES
    2. Sync can be implemented without requiring IIS, WCF, etc. - network admin is hesitant about implementing web servers, etc. so its preferred that all we need is a VPN connection between the remote laptop and the corporate db - YES, for as long you can connect to the database servers
    3. Sync Fx can be used to initially deploy the remote db file - YES, you can generate a SQL CE SDF file using GenerateSnapshot to initialize other databases/replicas.  
    4. Sync Fx can update remote db schema to match corporate db schema - NO, Sync Fx doesnt automatically handle schema changes, you will have to write some code to handle this.
    5. Sync master table data from corporate db to local db -YES, you can configure sync Download Only, Upload Only or Bidirectional
    6. Sync select group of transactional table data from local db back to corporate db (multiple apps may use the remote db so each app is looking to sync only those transactional tables that it interacts with - not all transactional tables) - YES, you can define SyncGroups or Scopes to specify which columns/tables to sync and also specify filters on these tables.
    • Marked as answer by Bo416 Friday, September 24, 2010 6:44 AM
    Thursday, September 23, 2010 11:51 PM
    Moderator
  • Thank you very much JuneT, this was a big help in obtaining buy-off from management
    Friday, September 24, 2010 6:45 AM