What is the best way to store a database?

Question

git

There is a small project in which there are only two participants. It is necessary that it be possible to synchronize data between databases on different machines, so that we always have the same state of the database. Right now it's just a .mdf file in the repository that will go sideways the first time we try to push changes at the same time.
Can you tell me what are the solutions to this problem? There is no opportunity to raise a personal server on which it would lie.

Answer 1

It's good to use migrations. You didn't specify the specifics, so you'll have to google like "postrgresql migrations" or whatever database you have.

Answer 2

Syncthing if you are not working at the same time.
Or google "DBMS replication <insert name of your DBMS here>" if you need both at the same time.

Answer 3

.mdf file = MS SQL

There is no opportunity to raise a personal server on which it would lie.

Microsoft Azure .

Answer 4

To lift a DBMS though where, and to refer to it to both. A server for it can also be raised in the cloud, and if it is, among other things, also a VPS, it will be possible to work with this database even from home.