Once you have selected the Microsoft Access tables and adapted the identifiers, if necessary, click on the Upsize button to start the migration process.
The following steps are then executed:
1. The selected Microsoft Access tables are exported to ADABAS one after the other. If a table already exists in ADABAS, you are asked whether or not you wish to overwrite this table.
2. The selected attributes of the Microsoft Access tables are created in ADABAS by means of DDL. If an error occurs, you can correct the corresponding SQL statement (see Section Setting the Options).
3. If the Attach exported tables option was not selected, the upsizing process terminates here. Otherwise, the tables migrated to ADABAS are attached to the Microsoft Access database. All the exported Microsoft Access tables are first renamed. The new name of a table is obtained by adding the suffix "_local" to the previous name. The names of exported tables or individual field names may have to be modified when they are created in ADABAS because, for example, they contain invalid special characters. In this case, the name of the attached table receives the suffix "_remote" and an "aliasing query" is automatically generated with the original table name and field name.
The ADABAS tables are attached to the Microsoft Access database one after the other. A status window indicates which ADABAS table is currently being attached.
On completion of the migration process, the number of exported ADABAS tables and the number of exported tables that were attached to the Microsoft Access database are displayed.
The result of the migration process is given in an upsizing report. Click on the Report button to view or print out the upsizing report, or the Close button to exit ADABAS AccessPlus.