We need a tool for dealing with database evolution/versioning. And we need the best! :)
Can you expert guys help us to find a great tool that has these features?
- Conceptual Model: The tool must work with a conceptual model so that the working schema can be translated to different DBMSs
- Versioning: The tool must understand the concept of version. The user is always working on a version or future version of the schema. As every version must be born from a parent version, the tool must be able generate evolution scripts from version A to version B, of course, with support to different DBMSs
- Templating: The tool must come with full conceptual/physical translation support for major DBMSs but if, by any reason, we need to alter the way it translates a particular information from the conceptual model to the physical model, we must be able to interfer by using templates