XMLSpy Database Connection Wizard

The Database Connection Wizard originally developed for Altova DatabaseSpy is now also used in XMLSpy, MapForce, and StyleVision.

In both the Enterprise and Professional Editions of XMLSpy 2008, the Database Connection Wizard provides a new, simplified, and standardized method to connect to any database for data import and export, or to create an XML Schema from a database structure (or vice versa).

The Database Connection Wizard in XMLSpy lets you to connect to any of these databases:

IBM DB2
Oracle
Microsoft SQL Server
Microsoft Access
MySQL
Sybase
Other ADO or ODBC databases

To take advantage of the Connection Wizard in XMLSpy to create an XML Schema from a database structure, follow these easy steps:

database connection wizard

Select 'Create XML Schema from DB Structure' from the XMLSpy Convert menu.
If it is not automatically selected, highlight the Connection Wizard icon at the upper left of the dialog to connect to a known database. (The other two options let you quickly build new connection strings for ADO and ODBC databases.)
Choose the radio button for your database type and click 'Next'.
The next steps vary in details based on the database type you choose, but you will be offered a list of databases already known to your system. Choose one and complete the connection.
A hierarchical tree of the database tables will be displayed. Simply choose the tables you want, modify any settings in the Options tab as necessary, and click 'Import'.

import db structure

XMLSpy reads the table structure, builds the XML Schema, and opens it in the graphical Schema/WSDL view for visualization and editing.

The Connection Wizard is just as convenient when you connect XMLSpy to a database for importing or exporting data. It works the same when you connect to a database using Altova MapForce and DatabaseSpy, and now in software version 2008, the Connection Wizard is the method for making database connections in Altova StyleVision too.

Download a free, 30-day trial of XMLSpy to try these features for yourself!

(ăk'rə-nĭmă'fōbē-ə)

Noun. Condition caused by exposure to overwhelming number of technology acronyms and buzzwords. Easily cured by the Altova Technology & Acronym Glossary.