Start the generation wizard
Display of certain generation targets can be filtered. Before starting generation, check that the selected generation target is activated:
1. On the desktop, click Main Menu > Settings > Options.
2. In the left pane of the options window, expand the HOPEX Solutions > Information Architecture folders.
3. Click the SQL Generation folder.
This folder contains all supported SQL generators.
4. In the right part of the window pane select those that you want to display in HOPEX Information Architecture
For generation targets, see Supported DBMS versions.
To start an SQL generation:
1. On the desktop, click the navigation menu, then Data Architecture > Tools.
2. In the edit area, click SQL Code Generation.
A wizard opens.
3. Define the Generation scope:
• database for a complete generation
• another SQL object for a partial generation.
4. For complete generation, select the database concerned and click Next.
5. Select the Generation Mode.
Four generation modes are possible:
• "Creation": generates creation orders for all objects.
• "Deletion": generates object deletion orders only.
• "Replacement": starts deletion of objects, then recreation (to avoid creation of duplicates for example). Supposes that the target DBMS supports this generation mode.
• "Modification": modifications only are taken into account. Unlike the other modes that act without taking account of what possibly exists, this mode enables connection to the DBMS server to obtain read-only access to the database already created. The wizard compares the HOPEX data file and the database information. After analysis of the two structures, the wizard generates the corresponding modification SQL orders. See Incremental Generation.
This mode is only available for the main DBMSs. See Supported DBMS versions.6. Click Next.
A dialog box then presents the objects generated.
7. Click Next.
Generation starts. A dialog box presents progress of the operation indicating the file(s) containing the result.
Click Open to see the list of the files generated.
When the extension used for the generated files is recognized by Windows, you need only double-click the file name to view it using the editor associated with the extension.
See also:
