|
You can use XML as an intermediate format for managing your UltraLite database, provided that the format follows the requirements for UltraLite usage. You can use XML as follows:
Load data into a new database with a different set of database properties/options.
Upgrade the schema from a database created by a previous version of UltraLite.
Create a text version of your UltraLite database that you can check into a version control system.
UltraLite cannot use an arbitrary XML file. The <install-dir>\win32 directory contains a usm.xsd file. Use this file to review the XML format.
Save the XML file to a directory of your choosing. You can either:
Export/unload a database to an XML file. If you are unloading a SQL Anywhere database, use any of the supported export methods. See Exporting relational data as XML.
Take XML output from another source—that source could be another relational database or even a Web site where transactions are recorded to a file. However, always ensure that the format of the XML meets the UltraLite requirements.
Open a command prompt.
Run the ulload utility, including any necessary parameters.
For example, to create a new UltraLite database in the file sample.udb from the table formats and data in sample.xml:
ulload -c DBF=sample.udb sample.xml