June 5, 2013 at 11:44 pm
Please solve my query
One of my Silverlight application is running.
This Application is using one central database (sql server 2008) and three other client databases (sql server 2008) at other server locations.
Our requirement is with minor changing or without changing in Silverlight application
When we make change in central database (insert update and delete in multiple tables) these change
Automatically occurs in all client database.
and when any change made in any client database all client as well as central database should be updated automatically.
For this I read some about Sync Framework and SQL Server 2008 Change Tracking.
But i have no idea about how will I do this.
Please help me. How can we achieve this.
June 6, 2013 at 6:24 am
There are two ways you could go: replication (managed by SQL Server) or change your applications to interact with a middle tier that will perform the updates (and queries) instead of the clients interacting directly with the various database servers.
#1 will require minimal code changes or development time
#2 is (potentially) more robust and scalable for the long term.
To make a recommendation I would need to know a lot more about your application and the databases involved. Also what is your business plan? Growth expectations? Transaction rates? etc. all this needs to be taken into consideration before deciding on a strategy that is optimum for your situation.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply