Create New Database

Parameters and options
STEP FORWARD supports multiple setups of data structures (such as Templates, Procedures, general and accounting data etc.) for differently configured user environments. Every such setup is stored in tables of a separate database (or schema, depending on RDBMS used). In STEP FORWARD, these setups are called "databases", regardless of the actual implementation of the underlying RDBMS.

To create a new database, assign it a unique name, observing the naming conventions of the underlying RDBMS (most common restrictions on the database name are: the first character in the name must be alpha, blank spaces are not allowed, etc. In STEP FORWARD, the database name is limited to 30 characters).

For some databases (McKoi, Mimer, MS SQL Server 2000) the name can be entered in the "Automatic" tab view.

Other databases (Sybase) may require some additional parameters set in CREATE DATABASE command, such as the name of the data segment and amount of space to be allocated off it. In these cases the full CREATE DATABASE command should be entered in the "Manual" tab view.


Database creation strategy
A new database can be created empty, with a minimal set of supporting structures; such database must be configured "from scratch" (this (None) is the default setting in Copy from prototype).

Alternatively, the new database can be created as an identical copy of an existing one, with a different name. This includes not only Templates, Procedures, Reports etc. but also the general and accounting data that may exist*. This copying from a prototype can save work when the new database has the same functionality as the existing one, or is sufficiently similar to it.

* Please Note:
If the prototype database contains general and accounting data, it should obviously be deleted from the newly created database, unless the purpose of the exercise is to rename the database (i.e. copy the original database to a newly named database and then delete the original database).

Special Note for Configurator Consultants:
This Copy from prototype feature can be used effectively to create custom vertical applications for resale. It lets you create a "new project" database by copying an existing database that is similar and then modify it to suit the custom specifications of the "new project." When the "new project" is completed it will remain in your "inventory of databases for resale"; however, on making a sale, you make a copy of a given database from your inventory, as a portable file, with Transfer Database.

In STEP FORWARD Version 4, only the currently logged-in database can be used as a prototype. All other entries in Copy from prototype list, with the exception of None, are disabled. If you need to create a new database with the prototype other than the current database, log out and log in again into the database to be used as the prototype.

 

Go to:
Index
Table of Contents