Link to home
Start Free TrialLog in
Avatar of John Darby
John DarbyFlag for United States of America

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?
SOLUTION
Avatar of gheist
gheist
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of John Darby

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....