Is it possible to sync two sql express servers with MS Sync Framework

.net sql sql-server microsoft-sync-framework
Konstantin Kuda picture Konstantin Kuda · Nov 3, 2011 · Viewed 7.8k times · Source

I have the next task.

Let's assume that we have below tables in a DB

Vendor
===========
Id
Name
.....

Product
===========
Id
VendorId
Name
.....

I need to be able to Sync main DB server with client DB server (one way sync), but there should be a possibility to apply some filters on sync process (for example for cleint DB 1 sync all Products where Vendor is John). As far as I understood - SQL Server replication will not help me, because in this case I have to use SQL Server Enterprise Edition. I researched that Sync Framework allows to use filter.
But, Is it possible to sync two sql express servers with MS Sync Framework?
I found that it is posiible to sync SQL Server <-> SQL Server SE and SQL Server <-> SQL Server CE

Answer

JuneT picture JuneT · Nov 4, 2011

the SqlSyncProvider in Sync Framework works with Sql Server, Sql Express or Sql Azure (even the upcoming Sql 2012 LocalDB).

check out this sample. Synchronizing SQL Server and SQL Express

simply change the connections strings to point to Sql Express for both local and remote provider and it should work.

the link contains a walkthrough of using a filters as well.

Related questions

how to insert datetime into the SQL Database table?

How can I insert datetime into the SQL Database table ? Is there a way to insert this query through the insert command in C# / .NET?

Read More
How to Troubleshoot Intermittent SQL Timeout Errors

We've been having a few instances per day where we get a slew of SQL Timeout errors from multiple applications (System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is …

Read More
How can you name the Dataset's Tables you return in a stored proc?

I've got the following stored procedure Create procedure psfoo () AS select * from tbA select * from tbB I'm then accessing the data this way : Sql Command mySqlCommand = new SqlCommand("psfoo" , DbConnection) DataSet ds = new DataSet(); mySqlCommand.CommandType = CommandType.StoredProcedure; SqlDataAdapter mySqlDataAdapter = …

Read More