|
|
|
DBScripter
is an ODBC database utility that creates a script of a database. A
script is a series of SQL commands that, when run, will create a
replication of the database or a portion of the database you
scripted in the DBMS you are running.
Any database that supports ODBC access can be scripted by DBScripter.
The databases DO NOT have to be on your machine, as long as they are
accessible from the machine running DBScripter.
DBScripter can script any database on four different levels, each
level can be used individually, or in conjunction to create a full
replication of the database’s structure, data and indexes.
Ver. 5.0 now allows you to switch users/schemas/catalogs, it also
allows to generate insert statements from free form sql, it can
output the data in CSV format, and
much more |
Structure Scripting - This level will
create a script of the tables in the database. It will find the
tables that are available in the database, or only those that you
may have selected and create a script that includes the definition
of each table, their columns and data types. You can use the
Advanced Structure Options to control the behavior of the script,
any special formatting required, or items to be included or
excluded, etc.
Data Scripting - This level will create a script of the data
found in all/selected tables in the database. It will create insert
statements to replicate all the data found onto another database.
Set the Advanced Data Options for any special formatting, as well as
for inclusion of a delete statement before each table's data
insertion.
Index Scripting - This level will create a script of the
indexes in the database. It will take all the indexes found for
all/selected database tables. It will create a script which includes
the type of the index (unique or not unique), and all applicable
related columns. Set the Advanced Index Options for any special
index name or column formatting, as well as for inclusion of a drop
statement before each index’ creation.
In order to make it easy to customize and create a script,
DBScripter provides with a Profile approach. A Profile is a named
set of definitions that govern the scripting behavior, by using
profiles, you can create different sets of custom definitions that
can be used at any time to change the actual script, these
definitions include special commands wording, default data
formatting, and goes as far as defining particulars of the tool to
be used to run the script.
DBScripter comes with pre-defined Profiles for the most common
databases. These can be copied or manipulated to create new Profiles
if there is ever a need.
DBScripter creates a script as defined with all the possible options
to the screen or to a file, or even save the script incrementally as
it is being created. |
|
|
