So after working with umbraco for a while, I run into a problem. So I have my Desktop PC and my Laptop. I often work on both of them. So how do I sync the SQL Database between these two machines? I tried to just store the .mdf and .ldf files on dropbox. This works out good most of the times, but from time to time it has sync issues caused by either permission problems or the file is still in use.

So how do you guys do it? I would say I have two options:

1. Put the database in a remote location. I fear latency here.
2. Sync the local database to a remote one and when switching workstations copy the remote one to the local first.

Both options require a remote database. Do you guys know any good tool for copying database from a local instance to a remote one? I know navicat but because it just deletes all tables in alphabetical order, it often won't work because of relationships in the database.

Thanks!