John Darby
asked on
GIT and storing DBs
Greetings,
we have a dev database which I would like to make available to developers, some of whom may be remote. Is storing in GIT a good idea?
we have a dev database which I would like to make available to developers, some of whom may be remote. Is storing in GIT a good idea?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with pepr - store the SQL dump for your database, not the actual database. Git is not the desired platform for data which changes as frequently as database tables do.
Which database system/file are we talking about? Even a CSV or INI file can be a database ...
/gustav
/gustav
ASKER
Thank you for insights; I think the method will be to generate a create.sql (for creating a new db) file and various development delta.sql files. Thank you for the help!
You can make daily clones of DB and call them snapshots, then pull schema deltas if really needed....