Sample Header Ad - 728x90

Sync'ing MySQL stored procedures to Git

1 vote
1 answer
1969 views
Is there a decent way to sync MySQL database source code (ie: functions and stored procedures) to git? I'd like to be able to develop stored procedures within my IDE and version control them in git so I can easily move them between servers, and identify changes to the code. It would be great if I could use git-hooks to auto update my stored procedures on push. It seems like a reasonable thing to want to do, but I don't see anyone doing things this way. I'd rather not attempt to store a long SP in a migration, or something like Liquibase. Ideally, I'd like to store the pure SQL in my git repo. Disclaimer: I'm a new DBA, so I may be missing something obvious.
Asked by blindsnowmobile (113 rep)
May 4, 2019, 06:06 AM
Last activity: Aug 14, 2019, 04:01 PM