Wednesday, January 21, 2009

Tip #33 – Generate SQL Scripts for Database Objects

ARC_GenerateSQL Advantage Data Architect has the ability to generate SQL Scripts for any data dictionary object. This allows for simple generation of statements which can be used to add the object in another data dictionary. You can generate the SQL Script by right-clicking on any dictionary object and choosing Generate SQL Script. This functionality is only available for data dictionary objects.

After selecting this option a new SQL window will be opened containing all the SQL necessary to create the object.

Create Function

To generate SQL to modify existing objects use the Data Dictionary Differentiator tool, which can be found on the tools menu (Compare Data Dictionaries). As with any generated code take the time to review and test it prior to implementation.

No comments: