To upgrade an existing UltraLite database or schema, choose one of the following options:

To upgrade an existing UltraLite database to version 11.0.0 (Sybase Central)

1. Complete the standard precautions for upgrading software, including backing up the database. See Important upgrade precautions.

2. Choose Start » Programs » SQL Anywhere 11 » Sybase Central.

3. Choose Tools » UltraLite 11 » Upgrade Database.

4. On the Database To Upgrade page, choose one of the following options:

   • An Old Database   Browse for an UltraLite database (*.udb or *.pdb).

   • An Old Schema File   Browse for an UltraLite schema file (*.usm).

5. Specify the connection parameters and then click Next.

6. On the Upgrade Destination page, choose one of the following options:

   • New Database   You must create a new database file and set the database properties you require. Follow the instructions in the wizard.

   • Use An Already Connected Database   You can choose a connected database from the list provided for you.

   • Use An Existing Database That You Are Not Connected To   Click Database to open the Connect window and connect to the existing UltraLite 11.0.0 database.

7. Follow the instructions in the Upgrade A Database Wizard. Click Finish.

If trusted root certificates were included in your previous version of UltraLite, add them to the new UltraLite database.

If users from the previous version of the UltraLite database do not appear in the new database, remember to add them. See Working with UltraLite users.

To upgrade an existing UltraLite database to version 11.0.0 (command line)

1. Carry out the standard precautions for upgrading software, including backing up the database. See Important upgrade precautions.

2. Ensure that the 11.0.0 version of UltraLite utilities are ahead of older UltraLite utilities in your system path. See Using the utilities.

3. Run the Unload Old Database utility (ulunloadold) to create an XML intermediary file using the following syntax:

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

   Ensure that you have:

   • Named the XML file that the ulunloadold utility is to create.

   • Used either the DBF or schema_file parameter in your connection-string, depending on whether you want to upgrade an old UltraLite database (*.udb or *.pdb) or an old UltraLite schema file (*.usm).

   All other options are optional.

   For more information about supported options for the ulunloadold utility, see UltraLite Unload Old Database utility (ulunloadold).

4. Execute the Load XML to Database utility (ulload) to reload the XML into a new or existing UltraLite database.

   If you are loading the XML into a new database, the -c connection-string option sets the connection parameters for that database (for example, the UID and PWD required to authenticate the UltraLite user).

   The -o [ extended-options ] you specify depend on whether you are changing the characteristics/properties of the database (for example, changing a case-sensitive database to a case-insensitive database).

   For a complete reference, see UltraLite Load XML to Database utility (ulload).

   For example, upgrading an UltraLite 8.0.x schema file named dbschema8.usm into an existing UltraLite version 11.0.0 database named db.udb with an intermediary XML file named dbschema.xml requires the following two commands:

   ulunloadold -c schema_file=dbschema8.usm dbschema.xml

   ulload -c DBF=db.udb dbschema.xml