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

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

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

•     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 10.0.1 (Sybase Central)

1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

2. Start Sybase Central by choosing Start > Programs > SQL Anywhere 10 > Sybase Central.

3. Upgrade your database by choosing Tools > UltraLite > 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 10.0.1 database   Choose this option to create the database and connect to it.

     • An existing UltraLite 10.0.1 database  Choose this option to change some database options or the collation using settings from the SQL Anywhere reference database. Ensure you choose a character set and collation appropriate for the data in the existing UltraLite database and its internal schema.

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

   • An Old Database  Browse for a 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 dialog and connect to the existing UltraLite 10.0.1 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 10.0.1 (command line)

1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

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

3. Open a command prompt and 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 discretionary.

   For a complete reference for this 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 set depends 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, upgrade an UltraLite 8.x schema file named dbschema8.usm into an existing UltraLite version version 10.0.1 database named db.udb with an intermediary XML file named dbschema.xml requires these two commands:

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

You can extract an UltraLite database from a version 10.0.1 SQL Anywhere database with either the Extract Database wizard or the Initialize Database utility (ulinit).

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

• 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 initialize/extract an UltraLite database from a SQL Anywhere reference (Sybase Central)

1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

2. Ensure you have already upgraded your existing SQL Anywhere database and prepared it with UltraLite usage in mind. If you need to update publications, be sure to do that before re-creating the UltraLite database.

   For SQL Anywhere upgrade procedures, see Using the utilities. For details on how to prepare SQL Anywhere for use with UltraLite, see Creating an UltraLite database from a SQL Anywhere reference database.

3. Start Sybase Central by choosing Start > Programs > SQL Anywhere 10 > Sybase Central.

4. Extract an UltraLite version of the SQL Anywhere database by choosing Tools > UltraLite > Extract Database.

   The Extract Database wizard appears.

5. Follow the instructions in the wizard.

To initialize/extract an UltraLite database from a SQL Anywhere reference database (command line)

1. Carry out the standard precautions for upgrading software. See Important upgrade precautions.

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

3. Ensure you have already upgraded your existing SQL Anywhere database and prepared it with UltraLite usage in mind. If you need to update publications, be sure to do that before re-creating the UltraLite database.

   For SQL Anywhere upgrade procedures, see Using the utilities. For details on how to prepare SQL Anywhere for use with UltraLite, see Creating an UltraLite database from a SQL Anywhere reference database.

4. Open a command prompt and run the Initialize Database utility (ulinit) to extract an UltraLite database using the following syntax:

   ulinit -a "SAconnection-string" -c "ULconnection-string" 
   -n pubname [ options ]

   Ensure that you have:

   • Provided connection strings for both the upgraded SQL Anywhere reference database and the new UltraLite database you are creating with this command.

   • Named the publications that contain the tables that your UltraLite database requires. To extract all tables, use -n*.

   All other options are discretionary.

   Note Because you are creating a new database, parameters like UID and PWD are used to create the initial user ID and password for authentication purposes. The SQL Anywhere database is not referenced in this case. However, to override other SQL Anywhere reference database property defaults use -o [extended-options]. See Supported extended options for a complete list.

For a complete reference, see UltraLite Load XML to Database utility (ulload). For more information on UltraLite database properties you can configure, see UltraLite Database Settings Reference.