mysql apply only required changes

261 Views Asked by At

I have 2 DB instances running on dev and prod.

In dev I have created a table students with the following schema

create table students (name varchar(20), age int, place varchar(100));

I created the same DB in prod using the above dev schema.

Now I have changed dev schema 3 times

alter table students modify name varchar(50);

alter table students modify name varchar(100);

alter table students modify name varchar(150);

once the dev DB is stable, I want to apply these changes to prod.
since all the changes I made in dev is only on one field, there is no need to apply 3 alter commands in prod. Instead, I need to apply only the 3rd alter command in prod.

Is there any tool available to apply only required changes?

0

There are 0 best solutions below