Y
Y
yurygolikov2017-08-11 22:34:37
MySQL
yurygolikov, 2017-08-11 22:34:37

How to get phased SQL migrations from MySQL WorkBench models?

Please describe in which direction to dig, what is the name of what I'm looking for?
I create models in MySQL WorkBench. I would like every time after I would modify this model and save the changes, only the modified SQL code of this model would be saved to me. That is, as it were, versioned migrations. What keyword should I search for this feature in WorkBench?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Kuznetsov, 2017-08-12
@DarkRaven

You just need to take the SQL script after changing the schema, and not apply it. When you select Database -> Synchronize Model..., at the end, you have a script. You just take it and apply it via migration.
I did not find another option - in 2013-2015, this is exactly how I developed a web application, the database of which was in MySQL and was developed using MySQL Workbench.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question