DDL-Extraction: Suppressing Schema_name

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
DanielLanz
Posts: 6
Joined: Mon 14 Apr 2008 13:58

DDL-Extraction: Suppressing Schema_name

Post by DanielLanz » Tue 16 Aug 2011 11:05

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

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

Re: DDL-Extraction suppress Schema_name

Post by Viktor » Tue 16 Aug 2011 13:10

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.

DanielLanz
Posts: 6
Joined: Mon 14 Apr 2008 13:58

Re: DDL-Extraction suppress Schema_name

Post by DanielLanz » Tue 16 Aug 2011 13:17

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 ?

Viktor
Devart Team
Posts: 68
Joined: Thu 06 May 2010 08:12

Re: DDL-Extraction suppress Schema_name

Post by Viktor » Tue 16 Aug 2011 13:44

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

Post Reply