Sunday 10 September 2017

mysql migrations

hello,I'm coding a backend app using mysql and sequelize.Initially I used sequelize-cli to generate and run migrations, but it did not ended well for two reasons:I had problems whenever I want to fine tune my database schema, i.e. using triggers, sometimes foreign keys creating/editing failed etc.I like to design and sync my database with mysql workbench's diagrams, which generates a sql migration file. Loading sql files from seqeulize-cli is difficult and sometimes it does not workSo my idea is to switch to a different migration tool for mysql which supports well .sql scripts.How do you manage your migrations? do you have any advice?

Submitted September 10, 2017 at 02:11PM by m3l7

No comments:

Post a Comment