This section provides a general description of the procedure for exporting Microsoft Access Tables to ADABAS. Subsequent sections will take you through the individual screens involved in the migration process. When you click on the Upsizing Wizard button, the following occurs:
1. The Upsizing Wizard analyzes the local database, its tables, the attributes and indexes of these tables, and the relationships between tables (if any were previously assigned by means of Edit / Relationships).
2. You are informed of any changes that need to be made to critical identifiers (identifiers containing characters that are not allowed in the ADABAS database) and must decide whether to initiate the export operation.
3. The Upsizing Wizard automatically creates a mirror image of each individual table and its indexes in the server database. If any default values, validation rules or required options were defined for table fields, they are also transferred to the target table. When this procedure has been completed and if the Structure only, no data field was not selected beforehand, the table in the server database is filled with the contents of the local table. In the final step, the local table is assigned its original name with the extension "_local" , e.g. a table with the name Customers would be named Customers_local after upsizing. The local tables are then no longer needed and can be manually deleted from the database once you have determined that the migration process was successful.
4. If the Attach exported tables field was selected when the migration process was initiated, the tables in the server database are automatically attached to the Microsoft Access database. In order to permit the attached tables to be addressed under their original names, the Upsizing Wizard generates a query with the original table name for each table attached. Since queries and tables for Microsoft Access applications are normally indistinguishable, this makes the swapping out of tables to the server database transparent for the application.
For a description of the individual steps in detail and in conjunction with the screens, see below.