This is kind of common scenario. I have 2 laptops(my wife's and mine) at home. I have SQL Server 2008 on both the machines. The databases get out of sync with each other.
I am trying to create a small application which will help me manage my bank and credit cards passwords. If either my wife or I change any of the accounts passwords, we update the Database. But this is causing headaches as the database on my machine gets out of sync with that of my wife's machine.
What options do I have to keep the databases in sync? Will Windows Mesh be of any aid? I am bit skeptical as I don't want to share my db files containing passwords on a public site.
It may be overkill for such a simple scenario, but this sounds like a case for merge replication.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With