Table Structure Update

khh · Post by **khh** » Sun 08 Oct 2006 00:11

Is there a way to make auto structure synchronization for tables?

Antaeus · Post by **Antaeus** » Mon 09 Oct 2006 10:30

Please describe more detailed what do you mean under "auto structure synchronization".

khh · Post by **khh** » Mon 09 Oct 2006 13:54

I am working on a new project witch is changing tables structure a lot almost adding new fields and sometimes changing or deleting existing ones.
Is there any way that this changes in database structure can be automatic. (for my users)
Like TmyStructure witch I give the final database structure (tables, fields, indexes, joins, store programmes ...) and
TmyStructure.new will apply it as new database.
TmyStructure.update will apply all changes to current database.
Or something like that.

Antaeus · Post by **Antaeus** » Mon 09 Oct 2006 15:28

MyDAC does not have such functionality. To implement this task you should execute DDL statements via MyCommand. For more information read MySQL Reference Manual.

khh · Post by **khh** » Mon 09 Oct 2006 18:18

Hopefully to see this functionality in future release

Thank you