| |
DBScripter for Oracle is a database utility that creates a script from any Oracle databases data, objects and/or source. A script is a series of SQL commands that, when run, will create a replication of the database, or a portion of the database. Scripts can be used to migrate data, upgrade databases, and even as a database backup.
DBScripter allows you to customize the script that will be created, you can select which objects or source to script, you can also add conditions to the data script thus scripting only a subset of the data. You can also ignore columns to be scripted, both for structural scripts (DDL) and data scripts (DML).
DBScripter also comes with a SQL Script feature that allows you to manually type a select statement and have its results scripted.
Any Oracle database can be scripted, the databases do not need to be local, as long as they are accessible from the machine running DBScripter using an Oracle client 8.x and above.
DBScripter uses an extremely carefully planned and designed algorithm for performing the quickest, most accurate database scripts; this algorithm allows for multiple levels of scripting to be performed on a database.
The scripting process is divided into two sections, Objects and Source, below is a list of whats included in each section:
Objects
Privileges - GRANT statements for System, Role and Object privileges.
Sequences - CREATE statements for sequences, including/excluding last values.
Tables - CREATE statements for tables, can be configured to include storage parameters.
Indexes - CREATE statements for tables indexes, can be configured to include storage parameters.
Constraints - ALTER table statement to create the constraints.
Data - INSERT statements to create the data. This can be configured to ignore columns, as well as providing data subsets.
Source
This section will generate CREATE OR REPLACE statements for the following objects source:
Triggers
Views
Functions
Packages
Packages Body
Procedures
Types
Types Body |
|