Hi Tiffany,
For small SQLite databases, the simplest thing is to dump as SQL text
and put that under version control. I've done this with DBs up to 100kb
or so, and it allows diff and merge to work as they usually do.
It's...not horrible. For larger databases, I've seen groups create a
database backup using the DBMS's native tool and then use something like
Git LFS to manage that backup as a binary blob. It works, but you then
have to use the DBMS's own tools for finding differences and reconciling
them.
Cheers,
Greg
On 2018-08-09 10:47 PM, Tiffany A. Timbers via discuss wrote:
Hi folks,
I am looking for SQL Database version control tool recommendations?
Ones that work with Git and are open source are ideal. I have never
tread in this territory before, so all opinions/options welcome!
Thanks!
Tiffany
*The Carpentries <https://carpentries.topicbox.com/latest>* / discuss
/ see discussions <https://carpentries.topicbox.com/groups/discuss> +
participants <https://carpentries.topicbox.com/groups/discuss/members>
+ delivery options
<https://carpentries.topicbox.com/groups/discuss/subscription>
Permalink
<https://carpentries.topicbox.com/groups/discuss/Ta7250f4266e508c5-M36d6d6a36d8c03d7a4317745>
--
If you cannot be brave – and it is often hard to be brave – be kind.
------------------------------------------
The Carpentries: discuss
Permalink:
https://carpentries.topicbox.com/groups/discuss/Ta7250f4266e508c5-M6caef8c352c65a5011f9bc27
Delivery options: https://carpentries.topicbox.com/groups/discuss/subscription
