Ispirer Website Ispirer Toolkit Overview Free Trial

SQL Scripts Options

Option name Descriptions
Generate the DROP TABLE Statement If checked, the DROP TABLE statement is generated before the CREATE TABLE statement
Remove Schema Names Lets you specify whether to remove schema (owner) names in SQL objects for DDL statements.
Trace Mode If checked the sqlways.trc file in the export directory is generated and each .sql file with the objects creation statements contains the commented source SQL code of the object in the same file.

This option controls whether the DROP statement is added to all the scripts or not. If the option is checked, the DROP TABLE statement is added to each file containing the DDL statement for the table. Also, where possible, for other database objects there will be created CREATE or REPLACE statement instead of just CREATE. For example for Oracle instead of:

CREATE PROCEDURE sp_proc
...

will be created

CREATE or REPLACE PROCEDURE sp_proc
...

NOTICE: If option Generate DDL is not checked this option is disabled.

If Yes is selected for “Remove schema names in SQL objects” option, the schema (owner) name is not added. This allows you to use the default schema (owner) name for the user who loads the DDL. This value is selected by default.
If No is selected for “Remove schema names in SQL objects” option, the schema (owner) name is added before the object name in each DDL statement created.
If Default is selected for “Remove schema names in SQL objects” option, all schema names from the source database will be saved, and the default schema names for the database will be mapped (for example, for the SQL Server - PG direction, the dbo schema will be converted to public).

This option is used to generate the sqlways.trc file in the export directory containing more detailed information regarding the export process. This information is primarily used by Ispirer developers to fix the export issues that may arise.

NOTICE: If this option is checked each SQL with the objects creation statements contains the commented source SQL code of the object in the same file.


If you have any other questions, please contact us: support@ispirer.com