PowerDesigner can generate database structure directly. To do so, you must connect to a data source using an ODBC driver.
To create a database directly:
1 Select DatabaseGenerate Database.
The Database Generation dialog box appears.
2 Type a destination filename for the script file in the File Name box.
3 Type a destination directory for the script file in the Directory box.
4 Select the ODBC Generation radio button.
5 Select creation parameters for tables, columns, and views.
6 Click the Keys and Indexes tab.
The Keys and Indexes page appears.
7 Select creation parameters for keys and indexes.
8 Click the Database tab.
The Database page appears.
9 Select database creation options.
10 Click the Options tab.
The Options page appears.
11 Select Script options.
12 Click the Selection tab.
The Selection page appears.
13 Indicate selection details and select or clear object check boxes for each type of PDM object to generate.
For more information on selecting a model, owners, and PDM objects see section Selecting objects for generation.
14 Click OK.
A dialog box asks you to identify a data source and connection parameters.
15 Select a machine data source from the dropdown listbox.
or Select a file data source from the dropdown listbox.
16 Type your user ID and password.
17 Click Connect and, if prompted by your data source, type additional connection parameters.
A message window shows the progress of the generation process.
18 Click OK.