Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 626
kkuda Avatar asked Apr 24 '26 04:04

kkuda


1 Answers

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.

like image 187
JuneT Avatar answered Apr 25 '26 20:04

JuneT



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!