| |
|
|
| |
DBScripter 5.0 Description |
|
| |
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 tables 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. |
|
| |
|
|
|
|