Export Options
If you wish to export only the table structure without the data, select Structure only, no data.
To export table attributes, select one or more of the following options:
- Primary Keys - Default Values
- Indexes - Validation Rules
- Relationships - Required Options
After the Microsoft Access tables have been exported, an attempt is made to reproduce these attributes in the newly created ADABAS tables.
If you wish to export the relationships (table relationships), you must export all the tables involved in a relationship.
Some of the Microsoft Access attributes have different names in ADABAS. The following list indicates the names of the Microsoft Access attributes in ADABAS:
Microsoft Access
Primary Key Primary Key
Index Index
Relationship Referential Constraint or Foreign Key
Default Value Default Value
Validation Rule Constraint
Required Option NOT NULL Attribute
The ADABAS attributes are created using the ADABAS Data Definition Language (DDL).
The following list shows the SQL statements that are used to create the corresponding attributes:
Primary Key
ALTER TABLE <table name>
ADD PRIMARY KEY (<column name>, ...)
Index
CREATE [UNIQUE] INDEX <index name>
ON <table name> (<column name>, ... )
Relation
ALTER TABLE <table name>
FOREIGN KEY (<referencing column>, ...)
REFERENCE <referenced table>
[ON DELETE CASCADE]
Default Value
ALTER TABLE <table name>
ADD DEFAULT <default value>
Validation Rule
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name>
CHECK <search condition>
Required Option
ALTER TABLE <table name>
COLUMN <column name>
NOT NULL
Also see Section 5, "data definition" in the ADABAS Reference manual.
If an SQL statement cannot be executed during the migration process because, for example, it could not be created correctly, it is displayed in a dialog box.
You can then either correct the SQL statement and execute it again (using the Execute button), or you can skip it (using the Skip button).
Attach Options
If you do not wish to attach the exported tables to your Microsoft Access database, clear the Attach exported tables check box.
If the tables are already available in the server database, for example, because an attempt to export them was not satisfactory, you can select Overwrite existing server tables to obtain that these tables are replaced without a comment. You can also select this option later during the migration process.
Select Save login ID and password locally if you wish to save your user name and password for the attached tables.
More Options
Uppercase Identifiers
Set this option if all identifiers (table names, field names) of the exported tables are to appear in uppercases in the ADABAS database.
Maximal Identifier Length
You can use this option to specify the maximum length of the identifiers for the exported tables in the ADABAS database.
Set ADABAS D Comments
When this option is set, the descriptions of tables or fields are stored as comments in the ADABAS system tables.
Skip All Errors
Set this option if you do not wish that ADABAS AccessPlus stops at each error to ask you to correct the SQL statement.