Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I currently have a database setup where my MSSQL 2008 R2 server runs on my local network, but the program runs on a notebook that is normally mobile and away from the network. VPN works, but I'm looking for a solution that that runs a local MSSQl 2008 R2 server on the local machine that syncs with the main server when the mobile system reconnects to the network, either through VPN or coming back on the network.

The notebook is running Windows 7 Professional 64 bit, the server Server 2008 Enterprise 64 bit.

share|improve this question

2 Answers 2

Give MS-SQL server permanent merge replication a try. It is a lot of work to setup the whole thing, but if you succeed it runs like a charm, when ever a network-connection is established.

This way you will be able to insert/update/delete data on either side, your notebook or your server on your local network. as soon a network connection is established the data will be synchronized.

share|improve this answer

Out of box Merge Replication is suitable for this.. But if you want your own implementation try Sync framework.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.