[DDLUTILS-28] Capture and creation of non-table entities - constraints, triggers, stored procedures and others

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.3
• Component/s: Core (No specific database)
• Environment: SQL Server, Oracle
• Assignee: Thomas Dudziak
• Reporter: Peter Millington
• Created: 12/Oct/05 18:22
• Updated: 03/Nov/08 22:06

Description

Database build includes many non-table items - commonly constraints, triggers, stored procedures and others which may be database dependant (Oracle sequences as an example).

Even the the common entities are generally not transportable between database types. The schema should allow multiple versions of each item to be created, one per database type which the user requires to support.

Can the ddl-utils package use user-customisable sql templates to create non-standard items from (new) generic XML tags?

Sub-Tasks

• Capture and creation of sequences: Open