search

ko4life-net / Fire-Drake-Project-v1453

https://ko4life.net/topic/1258-ko4life-fire-drake-project-v1453/
GNU General Public License v3.0
9 stars 9 forks source link

Database Submodule under Version-Control #1

Open ko4life-psko opened 3 years ago

ko4life-psko commented 3 years ago

Since there will be a lot of database editing, there is a need to automate the process of putting the db changes under git. e.g. creating a script that will use MSSQL's exporter to dump all the database as alter scripts including content. More details regarding this can be found here.

The process should be relatively easy and will allow to track each table changes in a separate file, so new users don't need to restore a .bak file, rather run a script that will import the database from the generated script.

brzezinski-grzegorz commented 3 years ago

So maybe we should create additional folder with Database and post just scripts as *.sql files with information about them as comments?

ko4life-psko commented 3 years ago

So maybe we should create additional folder with Database and post just scripts as *.sql files with information about them as comments?

Exactly, but the scripts should be generated automatically in another repository. Separating it into modules making it easier to collaborate.

stevewgr commented 2 years ago

In case you're still working on this, we implemented something similar in here: https://github.com/stevewgr/ko-db

basically we build the db from scripts with a script.