DDL-Extraction: Suppressing Schema_name

DDL-Extraction: Suppressing Schema_name

Postby 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
DanielLanz
 
Posts: 6
Joined: Mon 14 Apr 2008 13:58

Re: DDL-Extraction suppress Schema_name

Postby 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.
Viktor
Devart Team
 
Posts: 68
Joined: Thu 06 May 2010 08:12

Re: DDL-Extraction suppress Schema_name

Postby 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 ?
DanielLanz
 
Posts: 6
Joined: Mon 14 Apr 2008 13:58

Re: DDL-Extraction suppress Schema_name

Postby 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
Viktor
Devart Team
 
Posts: 68
Joined: Thu 06 May 2010 08:12


Return to dbForge for Oracle