Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database creation approaches


Creating an UltraLite database from an XML file

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.

  1. 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.

  2. Run the ulload utility, including any necessary options.


The database is created.


You can now connect to the database and build tables and other database objects.


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

 See also