Copy DB #1 to DB #2 with changes in DB #2 applied to DB#1

[Guest_imported]

Hello,

Is there a database utility which manages the changes in the database itself. Maybe my sentence framing is wrong.

Like for example I have a sql database with about 100 tables in it. All those tables contains more than 10000 records. Currently, the database verison is version 1 (DB #1). Now after some time, I made a change in the application and that in consequence affected the changes in the database structure. So some of the tables in the database will now have an extra field and one field will be deleted or renamed, for example which will make DB #2.

Is there a utility for mysql or a generic database that will allow me to say that "copy DB#1 to DB#2 with the new field that was added will now be empty, the deleted field will be removed with all the data for that field and all other data will be intact" or something of that sort.
If there is a change in the field name, I should be able to do that too.

Is there a utility available for doing that?

Regards,
KT

 

[angiole]

If DB1.Table1 has Col1, Col2, Col3, then
try creating a table from a result set.

Ex:
Create Table New_Table as (
Select Col1,
Col2,
" " AS Col4
From Table1
Where ...)