Hi,
I am using MySQL.
do you know a php script or a software which do this:
- compare 2 db schemas and update the production schema from the DEV schema.
Only the schema, not the DATAS!!
For example:
- you add a table within your DEV environment -> it creates the table
(without the data) on the production server
- you add a field within a table within your DEV environment -> it creates
adds the field within the same table (and of course set the defaut value of
all the existing fields for this column) on the production server
- optionnaly, only if you set a flag, it should remove fields on the
production environment if it has been removed on the dev environment (but
not always, only if you set a flag!!)
All the existing softwares do a "easy" synchronization (mydb etc )!!
They only create new tables (the full tables) and export datas!!!
Is there a way to detect news fields and update the schema???
Many thanks
Rod