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).
Was this helpful?