Workspace
Setup - The Database Update Framework
If you haven't done so, read
the First Time
Usage to setup the two tools used by the
framework.
For each workspace the framework
is to be used for there are three steps you need to perform.
- Add as a library to your workspace. Select
Maintain Libraries from
the Studio's Tools menu. Click the Add
Library... button and navigate
to the DbUpdateFramework Home folder and select the *.sws
file that corresponds to the Studio version. Click "Yes"
when asked if you want to add the path as a relative path.
- Create DbVersion table. The second step is
to create a table & a column/field where to keep the current
database version (pnVersionNumber). Select Create
DbVersion Table from the Studio's
Tools menu. The 'Filelist No:' shown at the bottom-left of
the program is the first free filelist slot found in your
filelist.cfg. Accept it or use the spin button to choose another
file slot number if required and click the 'Create Table'
button. This will by default create a table and a Numeric
type data field of size 4,2 where the current database version
will be kept. Note: It is possible to use a table of
choice if preferred, but it is easier to use the default DbVersion
table.
- Create a SQL Connection. If you are going to
use a SQL back-end database (MSSQLDRV_ID, DB2_DRV_ID, ODBC_DRV_ID,
SQL_DRV, ORA_DRV, MDSMYSQL or MDSPGSQL) you need to establish
a connection to the Server or DSN. Select the SQL Connections Manager tool
from the Studio's Tools menu. If you need help press F1. Always
press the 'Check Login' button to make sure all entered data
is correct. Click the OK
button to exit the pop-up dialog and
press the Save Changes button
to save the SQLConnections.ini file to
disk.
Note: If you have selected "Microsoft
SQL Server" as database type and the database doesn't exist yet,
please enter 'Master' as the database. The 'Master' database is always
available and can be used to make an initial connection to the MS-SQL
server. If you need to create a new database with your update code
there are functions to do so. See: "How To Use It - Important!
- Sample Code 2".
Next Topic
How
To Use It