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?