I have to compare two MySql database data, I want to compare two MySql schema and find out the difference between both schema.
I have created two variables Old_Release_DB and New_Release_DB. In Old_Release_DB I have stored old release schema than after some modification like I deleted some column, Added some column, Renamed some column, changed column property like increase datatype size (ex: varchar(10) to varchar(50)). Than it became new release schema that I have stored in New_Release_DB.
Now I want to Table Name, list of column name which has changed in New_Release_DB, and changes along with column name.
Table_A Column_Name Add(if it is added), Table_A Column_Name Delete(if it is deleted), Table_A Column_Name Change(if its property has changed)
I am trying it in Shell script in Linux, But I am not getting it. Please let me know If I can use other script like python or java.