1
Suggestions and Requests / Re: DDL to manage a changing schema
« on: August 20, 2008, 08:33:50 pm »
Hello David,
thanks for your answer! I don't want to say that JDevelope is the perfect tool (otherwise we would not look for an alternative!). It has it's limitations when you try to synchronize the datamodel with multiple database instances, and it doesn't support the conversion between different database types.
What we need is, to synchronze the logical database model with differeet database instances of different vendores (Oracle and MySql). We hoped, that we achieve this with EA, because it supports also the data type mapping. However es far as I can see now the database type is an attribute of the table. So when we want to generate a DDL for the different database types we have to change this in all tables?
However EA cannot help us in this aerea, so we'll have to look for another tool for this purpose. We just want not to spent money for another tool when this features are available in EA in the next two months.
Best regards Thomas
thanks for your answer! I don't want to say that JDevelope is the perfect tool (otherwise we would not look for an alternative!). It has it's limitations when you try to synchronize the datamodel with multiple database instances, and it doesn't support the conversion between different database types.
What we need is, to synchronze the logical database model with differeet database instances of different vendores (Oracle and MySql). We hoped, that we achieve this with EA, because it supports also the data type mapping. However es far as I can see now the database type is an attribute of the table. So when we want to generate a DDL for the different database types we have to change this in all tables?
However EA cannot help us in this aerea, so we'll have to look for another tool for this purpose. We just want not to spent money for another tool when this features are available in EA in the next two months.
Best regards Thomas