We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in offline i.e. when the user is out of office user has to use the data which comes from the SQL Express. Once user connects to office LAN all the data from SQL Express has to be automatically synch with centralised database.
How to catch the data into SQL Express in stead of using the default Caching data into DataSets for working in offline mode. Please kindly help me in order to solve this issue.
Thanks in advance,
Hello:
I've moved your question to the SQL Server Replication forum, as your issue seems to be more in their domain.
Thanks!
Mike Hernandez
Community PM
VSTO Team
You could make the SQL Express as a merge subscriber to the Central Server. When connected, the middle tier can make the user talk to the Central Server directly and when offline, the middle tier needs to connect the user to the SQL Express instance.
When connected to the Central Server, Merge replication can keep changes in sync and when offline, changes can happen at the Central Server and SQL Express independenlty and when connection is restore, the changes will be synched across.
You will need to take into account if you are going to have conflicts and if so, an appropriate resolver.
Please see Books Online for more information.
No comments:
Post a Comment