Difference between revisions of "Db-edit"

From dbscript Online Help
Jump to: navigation, search
(New page: {{Template:dbsweb}})
 
Line 1: Line 1:
 
{{Template:dbsweb}}
 
{{Template:dbsweb}}
 +
 +
=== MSSQL Server database properties ===
 +
 +
Server, Catalog, Username and Password must be provided for live database.
 +
 +
=== Oracle database properties ===
 +
 +
You can define the Oracle connection in two ways:
 +
 +
    * set “Server” to the instance name listed inside tnsnames.ora and leave “Catalog” empty
 +
    * set “Server” to server:port, and “Catalog” to the service name (as in tnsnames.ora)
 +
 +
A new field called “Import Options” allows you to define the scope of the schema import:
 +
 +
    * “USER” (the default value)
 +
    * “ALL:” + list of user names
 +
    * “DBA:” + list of user names
 +
 +
The user specified in “Username” needs to have access to the ALL_ and DBA_ catalog views, respectively.
 +
 +
[http://devio.wordpress.com/2009/06/10/documenting-oracle-databases/ Documenting Oracle Databases in dbscript]

Revision as of 23:38, 10 June 2009

Online Documentation for dbscript by devio

MSSQL Server database properties

Server, Catalog, Username and Password must be provided for live database.

Oracle database properties

You can define the Oracle connection in two ways:

   * set “Server” to the instance name listed inside tnsnames.ora and leave “Catalog” empty
   * set “Server” to server:port, and “Catalog” to the service name (as in tnsnames.ora)

A new field called “Import Options” allows you to define the scope of the schema import:

   * “USER” (the default value)
   * “ALL:” + list of user names
   * “DBA:” + list of user names

The user specified in “Username” needs to have access to the ALL_ and DBA_ catalog views, respectively.

Documenting Oracle Databases in dbscript