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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Utilities Reference

UltraLite Unload Database to XML utility (ulunload) Next Page

UltraLite Unload Old Database utility (ulunloadold)


Unloads UltraLite version 8.0.2 to 9.0.x databases and/or schema files (*.usm) into an XML file.

Syntax

ulunloadold -c "connection-string" [ options ] xml-file

OptionDescription
-b max-size

Set the maximum size of column data to be stored in the XML file. The default is 10 K. To store all data in the XML file (that is, to have no maximum size), use -b -1.

-c "connection-string"

Required. Connect to the database as identified in the DBF or file_name parameter of your connection-string. If you do not specify both a user ID and a password, the default UID of DBA and PWD of sql are assumed.

-f directory

Set the directory to store data larger than the maximum size specified by -b. The default is the same directory as the XML file.

-q

Run in quiet mode. Do not print messages.

-v

Print verbose messages.

-y

Overwrite xml-file without confirmation.

xml-file

Set the name of the XML file that data will be unloaded into.

Remarks

Do not unload UltraLite version 10 databases with this utility. Use the ulunload utility instead. To create an UltraLite 10 version of the database, load the xml-file with ulload.

Preservation    Unloading a database does not preserve:

To confirm what database options or properties have been preserved, run ulinfo after you have reloaded your database with the ulload utility.

Column data overflows    If column data exceeds the maximum size you specified with -b, the overflow is saved to a *.bin file in either the same directory as the XML file, or in the directory specified by -f. The file follows this naming convention:

tablename-columname-rownumber.bin

Errors    This utility returns error codes. Any value other than 0 means that the operation failed.

See also
Example

Upgrading an UltraLite 8.0.x schema file named dbschema8.usm into an UltraLite version 10 database named db.udb requires these two commands:

ulunloadold -c SCHEMA_FILE=dbschema8.usm dbschema.xml  
ulload -c DBF=db.udb dbschema.xml

Upgrading an UltraLite version 9.0.x database for Palm OS named palm9db.pdb to an UltraLite version 10 database named palm10db.pdb requires these two commands:

ulunloadold -c DBF=palm9db.pdb dbdata.xml
ulload -c DBF=palm10db.pdb -p Syb dbdata.xml