Microsoft Sync Framework for DB

Amit Gupta

Hi all

I am new to MS Sync Framework and I want to sync the 2 database (MS Sql Server) but I am unable to solve if there is any change in schema (like column added) in one of the DB.

The thing is I had made an application in WPF that uses Sql Server as its backend (which is in online server). Now client don't have proper internet connectivity to work with database online, so they want to work with it offline and which is being sync with online database when they comes in the range of internet connectivity.

So, I researched and found thats Sync Frameworks is doing all these thing and I tried this with my 2 local database and it works like a charm but one thing comes in my mind that when the application is updated and if there is any change in schema then it fails.

Can any one help me who had worked or have knowledge of Ms Sync Framework or any other option to do that.

I had aearched for any schema change but no such article found.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Hi Chetan
I have gone deeper and found that sync framework creates some triggers and store procedure in Sql Server and few things more (that I unable to find).

Lets assume that I updated the client db but the stuff made by sync framework cannot update that and cause exception to match the schema.
Chetan Ranpariya9y ago
For the situation of application change you will have to deploy the new version of the application on the client machine. So along with it you can also update database on that machine.