Synchronize 2 sql server 2019 database over intermittent connection (no replication)

I’m a PostgreSQL DBA learning SQL Server 2019.

The setup :

  • 1 Desktop, 1 Laptop
  • Both running SQL Server 2019 Developer
  • Windows 10 Home (nothing else, no active directory, nas, san, …)
  • a database in simple recovery model, with partial containment enabled

The problem :

  • I want to be able to synchronize a database from my laptop to the desktop, or the other way around
  • I don’t want to use replication (log shipping or others) since I may not connect both servers for a long time and my laptop is very limited in disk space. (I’m in simple recovery model for the same reasons)
  • both (desktop/laptop) database must be writable (so no primary/secondary)
  • if the database is modified on both side, I’ll lose modification on one side. It’s ok! I accept this.

The solution I know :

  • Create a SQL Server dump, send it to the desktop over shared network, apply the dump. or the other way around.

Is there a way to export a database to another database, on demand ? Or is the dump/transfer/restore the way to go ? (that’s what I would do with PostgreSQL)

I don’t know all the SQL Server keywords and terminology and my google-fu was unsuccessful. Most solutions I find are obviously about how to set up replication over a reliable/permanent network. which doesn’t fit my requirements.

Database Administrators Asked on November 11, 2021

1 Answers

One Answer

Well... it turn out it couldn't be easier.

Right click on database -> Tasks -> Copy database...

Answered by ker2x on November 11, 2021

Add your own answers!

Related Questions

Slave_SQL_Running_State init

0  Asked on February 14, 2021 by euratus


How to cast in oracle -Spatial Database?

1  Asked on February 13, 2021 by marchest


Mongo exception: connect failed on reboot

2  Asked on February 12, 2021 by jack-jack


SQL Server Application paths to include in server backup?

1  Asked on February 4, 2021 by john-rock-bilodeau


ERROR: no schema has been selected to create in

3  Asked on February 2, 2021 by emanuele-paolini


ORACLE ASM present one or more LUNs?

1  Asked on January 31, 2021 by miguel-ramires


Ask a Question

Get help from others!

© 2021 All rights reserved.