Tracking changes in the database structure

Question

How can I track all changes in my database?

I need a way to find out what changes I made to the database so that I can make the same changes on another server.

For example, if I added a new field to one of the tables, I would like to know which field was such that I could add the same field to another database.

Answer 1

The steps that people usually go through are faced with the following problems:

• Change db development in any way you need at the time.

• Ready to deploy the new version of the application - make sure that the production database is also updated, saving the data.

• , . . , .

• , - .

• , ​​ .

• .

, 1-3 , , 4-6, 1-3 .

Answer 2

LiquiBase

XML, VCS , .

Answer 3

, db MySQL Query Browser. , . script .

, , , . , .

Answer 4

MySQL ? , - .

Answer 5

phpmyadmin GSoC, . ,

Answer 6

: - Worbench - EMS sql manager - SQL Maestro -

script

Answer 7

, - ?