I am evaluating the DDT right now and have a few questions about its capabilities. With our application and the databases that we deploy, we have the following requirements:
1. Some of our customers add their own custom fields into the tables for reporting purposes, and also add custom tables for the same purpose. If we were to use the DDT to deploy the db, would it overwrite all custom tables/fields that the users put into their database? Is their any way to allow additions to the DDT deployed database structure to remain intact with each deployment?
2. We have a few triggers in our db right now and plan to add more. Can the DDT handle these?
3. We may end up having to support other providers besides SQL. If this happens, we would need the ability to generate some sort of script to go between database versions (DDT packages) so that we could convert from SQL to another language (Oracle, DB2, etc). Is this possible at all? My real question here is can the DDT generate some sort of SQL script to run on a database which would bring it to the correct version.
Please let me know if the above are possible, and if so a little bit of detail on how they can be accomplished using the DDT. Thanks!