Synchronize 2 sql server 2019 database over intermittent connection (no replication)
2
votes
1
answer
177
views
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.
Asked by ker2x
(121 rep)
Jul 21, 2020, 07:28 PM
Last activity: Jul 11, 2025, 02:03 AM
Last activity: Jul 11, 2025, 02:03 AM