Note: Creation of some objects is not supported, e.g. Objects not supported in Toad Data Modeler External Tables (specific for Greenplum db).Most extra objects are based on PostgreSQL 8.2 database. Trigger - Triggers can be created, but functionality is limited considerably!Įxtra Objects of Greenplum database supported in Toad Data Modeler Permissions can be set for entities, views and functions.įoreign Key (referential integrity) - Foreign key constraints are not supported in Greenplum Database. Greenplum is based on PostgreSQL 8.2, therefore functionality and features available are similar. No Inherit option to allow not inherited constraints.Buffering parameter option available for gist index.Index Access Method have new option spgist.Type - Array Type allows BOOLEAN data type.Trigger - Trigger event allows OR option, set for generating SQL script in Extended Value, option Create or Replace.Unique Constraints - Business Time Without Overlaps option added.Indexes - Business Time Without Overlaps option added on General pane.Functions - Secured checkbox on Function Parameters pane added for function types External Scalar, External Table, OLE DB, SQL.New pane Generated replaced former Identity/Identity and Row Change Timestamp. Period Definition (BUSINESS_TIME/SYSTEM_TIME values) option added Supported features - reverse engineering, alter script generation, SQL/DDL script generation, reports.Ĭompression Mode option added with values ADAPTIVE/STATIC New Support Support for IBM DB2 10.1 (LUW) Review the following sections for new features and updates in this release: Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists. Quest Software's Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures.
0 kommentar(er)
