xml spy
Previous  Top  Next
Creating a database schema

XML Spy enables you to create a schema based upon an external database file. Microsoft Access databases, as well as ADO and ODBC compatible databases, are supported.

Goal of this section:
To convert an existing MS Access database into a schema file, having the same table structure.

This will be achieved by:
·Using the menu option Convert | Create Database Schema, to create the schema in XML Spy.  

·This example uses the DB2Schema.mdb file supplied with this tutorial. The Relationships view of the DB2schema.mdb file is visible in the diagram below. Use the menu option Tools | Relationships in MS Access, to view the relationships.  

tut_66a  



Previous  Top  Next

© 2002 Altova