Page 1 of 1
Table Structure Update
Posted: Sun 08 Oct 2006 00:11
by khh
Is there a way to make auto structure synchronization for tables?
Posted: Mon 09 Oct 2006 10:30
by Antaeus
Please describe more detailed what do you mean under "auto structure synchronization".
Posted: Mon 09 Oct 2006 13:54
by khh
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.
Posted: Mon 09 Oct 2006 15:28
by Antaeus
MyDAC does not have such functionality. To implement this task you should execute DDL statements via MyCommand. For more information read MySQL Reference Manual.
Posted: Mon 09 Oct 2006 18:18
by khh
Hopefully to see this functionality in future release
Thank you