Have Geek Brain

SQL Server 2008: Communication Between Compact 3.5 and Express

Q: How can we connect a SQL Server CE database to a SQL Server Express database? We cannot use Merge replication because you can only be a Subscriber in SQL Server Express, not a Publisher.

Additional background information:

We have an application structured as follows: 1) Our headquarters running SQL Server 2008 2) Branch offices running SQL Server 2008 Express 3) Machines running SQL Server Compact

Each machine must connect to its own branch to send data. The branch must then contact our headquarters to send the data. Synchronizing data between machines and branches should be done fairly frequently (preferably twice a minute), as branch operators may need to respond to emergencies. Synchronization between branch and headquarters may be less frequent (I think daily). However, we will need to support network outages.

We do not expect conflicts to be resolved, so I would like to avoid using Microsoft's sync services. Looking at this SQL Server Express BOL page I can see that Merge Replication can meet our needs and I plan to use it between our HQs and branches, but as I said above, we need a way to connect a compact DB to Express.

+1


a source to share


2 answers


Have a look at Microsoft Sync Framework :



a complete synchronization platform providing collaboration and offline for applications, services and devices supporting any data type, any data store, any transfer protocol and network topology.

+1


a source


You can create an application to connect to an instance of SQL Express and do a manual sync — kind of like home replication. I would deploy the application to my SQL CE machines and "pull" the information needed to sync with each machine.



+1


a source






More articles:


All Articles