Devart Forums

I'm testing dbForge for Oracle (V3.0.82)
Extracting DDL works fine via SubTab "Text". But I need a DDL without schema_names. The reason for that is, that I need multiple installation in one oracle-instance. (eg. Dev/Test/Prod1/Prod2).
Is there a option to adjust this.

I would like to have additional configuration flags
Prefix with schema_name
Use "Create or replace"
Include "storage clause"
Include grants
PrimaryKey in Table_Definition
Relation in Table_definition

DanielLanz wrote:I'm testing dbForge for Oracle (V3.0.82)
Extracting DDL works fine via SubTab "Text". But I need a DDL without schema_names. The reason for that is, that I need multiple installation in one oracle-instance. (eg. Dev/Test/Prod1/Prod2).
Is there a option to adjust this.

I would like to have additional configuration flags
Prefix with schema_name
Use "Create or replace"
Include "storage clause"
Include grants
PrimaryKey in Table_Definition
Relation in Table_definition

Use the "Generate Schema Script" operation in the context menu of Database Explorer to generate DDL of the schema or selected objects. Also you can use the Generate Script AS (create, drop, etc. ) operation.

Viktor wrote: Use the "Generate Schema Script" operation in the context menu of Database Explorer to generate DDL of the schema or selected objects. Also you can use the Generate Script AS (create, drop, etc. ) operation.

I can't find "Generate Schema Script", is this command aviable in the Express version ?

DanielLanz wrote: I can't find "Generate Schema Script", is this command aviable in the Express version ?

"Generate Schema Script" is not available in the Express edition.
You can use fully-functional trial version for testing: dbForge Studio for Oracle 3.0 Professional Trial