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.
1.The library should be added to your workspace and this is how you do it. 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.
2.Create a SQL Connection if you are not only going to work with embedded DataFlex tables. 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 DUF SQL Connections 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, when editing connection properties. 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