I’d like to know whether the following is possible in Visual Paradigm. I have searched around and tried things already, but couldn’t get it right:
- Is it possible to change the default data type mappings between different dbms, eg. when switching from postgres to Oracle to define a bigint to become a number(18)?
- Is it possible to augment the data types for a specific database?
- Is it possible to add triggers to an ERD that only apply to a specific dbms? eg. I have ERD with Oracle, Sybase and Postgres, but the triggers are for auto increment columns in Oracle and not needed by sybase or postgres. So basically can you have one ERD with some elements only generated for some dbms’s?
- Is it possible to provide your own sql generation templates or change existing ones?