On my main development workstation I have around 20 databases. Every so often I will work from home on my laptop instead, where I also need a copy of these databases. Because working from home is fairly infrequent, the databases are often a long way behind my main development databases on my workstation.
Currently what I do is take a backup of the workstation database, and then restore it on my laptop, but this is becoming time-consuming. Especially since some software projects require multiple databases.
Is there a more automated way of achieving database synchronisation between my main workstation and my laptop?
Would something like replication come with its own problems? Ideally I want it as automated as possible.