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

SQL Anywhere 11.0.0 » SQL Anywhere 11 - Changes and Upgrading » Upgrading to SQL Anywhere 11 » Upgrading UltraLite » Upgrading version 9 and earlier UltraLite databases


UltraLite database upgrade tools

You can upgrade an existing UltraLite database or schema with either the Upgrade Database Wizard or the Upgrade Old Database utility (ulunloadold).

  • Upgrade Database Wizard   Choose the wizard if you want to be guided through the process and have help choosing available properties/options.

  • ulunloadold utility   Choose the utility if you have either of the following requirements:

    • You only want to upgrade named tables into a new database.
    • You want to implement a batch-oriented process.

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

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

  2. From the Start menu, choose Programs » SQL Anywhere 11 » Sybase Central.

  3. Upgrade your database by choosing Tools » UltraLite 11 » Upgrade Database.

    The Upgrade Database Wizard appears. Before continuing ensure you have decided:

    • What the source is. You can choose either a database or a schema file.
    • Where to output the upgraded database. You can choose from either:
      • A new UltraLite 11.0.0 database   Choose this option to create the database and connect to it.

      • An existing UltraLite 11.0.0 database   Choose this option if you already have already created a new database and you want to apply the schema of the old database to the new database.

  4. Choose your upgrade source by selecting the appropriate option:

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

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

  5. Connect to the file you selected and then click Next.

  6. Choose your output destination:

    • 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 of the wizard to make additional choices relating to your output destination. If you had trusted root certificates included in your previous version of UltraLite, ensure you add them back into the new UltraLite database.

  8. Click Finish to upgrade the database.

  9. If you had users in the previous version of the UltraLite database, and if you do not see them in the new database you have created, 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 or not 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 or not 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