Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sync Databases on two computers

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.

like image 466
AlwaysAProgrammer Avatar asked Feb 15 '26 02:02

AlwaysAProgrammer


1 Answers

It may be overkill for such a simple scenario, but this sounds like a case for merge replication.

like image 168
Joe Stefanelli Avatar answered Feb 17 '26 15:02

Joe Stefanelli



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!