A
A
Alexey Smirnov2018-10-31 20:58:38
SQL Server
Alexey Smirnov, 2018-10-31 20:58:38

How to synchronize SQL database between two computers?

Hello.
I recently installed SQL Server 2017 Express from Microsoft. And I plan to create databases in it.
I have 2 computers on the local network: a laptop and a desktop computer. I need to synchronize future databases between these two computers so that the programs I write can access these databases from both computers.
In what ways is it possible to automatically synchronize a database between two computers?
PS Desirable ways without a monthly fee like renting remote servers.
PPS Previously, I used text files to store data and synchronized them through MEGA cloud storage. It was convenient. But I don't know if it's possible to synchronize SQL databases in the same way (via MEGA).

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladimir Skibin, 2018-10-31
@ERAFY

I have 2 computers on the local network

What for then for everyone the base? start a base on one of them and connect with it alone.
If you still need remote access, then it's better to throw VPN / Proxy / IPv6 to the server with SQL.
Data Synchronization is disabled in Express, so you don’t even have to look, there will be crutches in the form of TableDiff and other things.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question