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.

  • What about source control and synchronizing schema changes? I kinda have the same issue going on and this gives me a good idea for a project. – Nelz Jun 21 '17 at 11:36
  • Good suggestion. I already do that using the data tools. The schema is not an issue as I use SSDT to publish out those changes from source control seamlessly. The project in question has dependent databases though, which can (and do) change in isolation from the project. These are the ones I am looking to seamlessly sync. – Laurence Frost Jun 21 '17 at 12:07
  • 1
    Which part of the backup & restore is time-consuming? Your effort to do it, or moving the bits? If the former, that's easily remedied via scripting. – alroc Jun 21 '17 at 12:49
  • @alroc the main issue is moving the backups between two machines over the web - this is always time-consuming and slow. – Laurence Frost Jun 21 '17 at 14:11
  • "Moving across the web"? Why not copy them to your desktop before you leave the office? – alroc Jun 21 '17 at 14:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.