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
DDL-Extraction: Suppressing Schema_name
Re: DDL-Extraction suppress Schema_name
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.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
-
- Posts: 6
- Joined: Mon 14 Apr 2008 13:58
Re: DDL-Extraction suppress Schema_name
I can't find "Generate Schema Script", is this command aviable in the Express version ?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.
Re: DDL-Extraction suppress Schema_name
"Generate Schema Script" is not available in the Express edition.DanielLanz wrote: I can't find "Generate Schema Script", is this command aviable in the Express version ?
You can use fully-functional trial version for testing: dbForge Studio for Oracle 3.0 Professional Trial