Use XML as an intermediate format for managing your UltraLite database.
UltraLite cannot use an arbitrary XML file. The %SQLANY16%\Bin32 and %SQLANY16%\Bin64 directories contains a usm.xsd file, containing the schema definition. Use this file to review the XML format.
Context and remarks
You can use XML to:
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.
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.
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. You must always ensure that the format of the XML meets the UltraLite requirements.
Run the ulload utility, including any necessary options.
To create a new UltraLite database in the file sample.udb from the table formats and data in sample.xml, run the following command:
ulload -c DBF=sample.udb sample.xml
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|