Hi,
I am currently working on Database syncronization between a local SQLCe database and a SQL Server database. In addition I am using scopes and filters in order to filter the syncronized data.
Following the example from
http://msdn.microsoft.com/en-us/library/ff928701(v=SQL.110).aspx I finally write a simple application which sincronizes between a local SQLCe database and a local SQL Server database with Sync Framework 2.1.
Dim clientSqlCeConn As New Data.SqlServerCe.SqlCeConnection
clientSqlCeConn.ConnectionString = "Data Source=" + localSQLCEPath
clientSqlCeConn.Open()
Dim serverConn As New SqlConnection
serverConn.ConnectionString = My.Settings.ServercdCatServidorConnectionString
serverConn.Open()
Dim syncOrchestrator As New Microsoft.Synchronization.SyncOrchestrator()
syncOrchestrator.Direction = Microsoft.Synchronization.SyncDirectionOrder.Download
syncOrchestrator.LocalProvider = New SqlServerCe.SqlCeSyncProvider("FilterByIdClient" + FILTER_VALUETextBox.Text, clientSqlCeConn, Nothing)
syncOrchestrator.RemoteProvider = New SqlSyncProvider("FilterByIdClient" + FILTER_VALUETextBox.Text, serverConn, Nothing, Nothing)
syncStats = syncOrchestrator.Synchronize()
The code above works fine assuming that templates and filters has been created (which are). Note that both connections are defined as local databases.
Now I would like to do the same syncronitzation but when the SQL Server database is only accesed by a WCF application service. I mean the SQL Server is not reacheable from the client, just for the WCF application service.
Note that in the syncronitzation process the SyncOrchestrator object needs the LocalProvider (the SQLCe database) and the RemoteProvider (SQL Server database which is actually defined as local). I wonder if it
I found this example
http://msdn.microsoft.com/en-us/library/cc807255(SQL.100).aspx based on framework 1.0. Is there an easy way to do this on framework 2.1?
Thank you
