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 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(50)). Then it became new release schema that I have stored in
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.