Create DB Structure based on Schema

Previous Top Next

Create DB Structure based on Schema

XML Spy allows you to create an empty database (or skeleton database) based on an existing schema file. The schema structure, defined by the identity constraints, is mirrored in the resulting database.

To create a Database based on a schema:

Open the schema file DB2Schema.xsd in the Tutorial folder.

Select the menu option Convert | Create DB Structure based on Schema.

Click the "Create a new MS Access database" radio button and confirm with OK.

Enter the database name in the Save as... dialog box (eg. DB-based-xsd.mdb).

The message "Export has been successfully completed" appears when the export has been completed successfully, confirm with OK.

Viewing the generated Database:

Double click the DB-based-xsd.mdb file in Explorer, or open the file in MS Access.

Double click the Division entry to see the Division Table.

Select the menu option View | Design view, or click the "View" icon to change into the Design view.

The Design view supplies information on the field properties of the database table: the field names, data types, etc. The parameter settings you see here have been transferred from the schema definition.

Previous Top Next

⌐ 2002 Altova