Overview of generating SQL code (SQL code)
Using Modeler you can use Table Relationships Diagrams to quickly model your SQL code through Database, Table, Column, Index and Relationship items and links. You can then use ACS to generate SQL code files from those items. The SQL script in those code files can be used create Tables, Columns, Indexes and Relationships in a target database.
After you have set up ACS, it works in the background and you do not have to interact with it. If ACS detects a change made by you in the model that affects the generated SQL code, ACS can automatically generate the relevant files.
ACS can generate SQL code for the following target environments:
• Oracle 10g
• SQL 2003
• SQL Server 2012
| You can customize the supplied ACS Code Generator DLLs through their associated TDK model. |
If you are learning to use
Modeler and
ACS, you may find the
Modeler tutorials useful. For information about downloading and opening the
Modeler Tutorials, see
Windchill Modeler tutorials.
To use ACS to generate SQL code you require an ACS license, a Modeler license and an ACS Language Pack for SQL license. If you want to customize the generation of SQL code, you additionally require an ACS Transformation Development Kit license.
For generic information about using
ACS, including deciding on a strategy for reverse engineering reversible properties, see
Overview of ACS (ACS).
For information about customizing
ACS Code Generator DLLs through
TDK, see
Overview of TDK (TDK) (link works only if
TDK is installed).