|
|
|
|
|
|
|
|
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...). This script generates the integrity constraints, the indexes, ... This script can be modified and run to create tables on a server. To generate the SQL script corresponding to an analysis (or to a file): - On the "Analysis" tab, in the "Analysis" group, expand "Generation" and select "Generate SQL script". The wizard starts.
- Select the tables/files for which the SQL script must be generated.
- Select the type of database for which the SQL script must be generated. All the available databases are listed.
- Specify the options for generating the SQL code:
- Generate DROP TABLE (code for deleting the existing tables).
- Generate the indexes.
- Generate the integrity constraints.
- The generated script is displayed. This script can be saved in a specific file in order to be modified, then run.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|