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

UltraLite application code upgrade tools

You can only use the Migrate C++ API wizard to help you migrate your ulgen-generated C/C++ source code. This wizard helps you identify embedded SQL that may no longer conform to version 10 specifications. If you can not complete the migration process, you can stop and save the SQL statements that you have modified to a *.uag file.

If this is your first time using the wizard, your table and statement source is the SQL Anywhere reference database. For subsequent iterations, you can use the saved *.uag file instead.

To migrate the UltraLite C/C++ API (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 the 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 for details.

3. Ensure you have upgraded an UltraLite database. Otherwise you need to extract an UltraLite database from the SQL Anywhere reference database.

   This UltraLite database is be used as the validation database for this process.

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

5. Migrate your C/C++ API application by choosing Tools > UltraLite > Migrate C++ application.

   The Migrate C++ API wizard appears.

6. On the SQL Statement Source page, choose the source from which statements and tables are read.

   • If this is your first time running the wizard, choose Connect to reference SQL database then click Database to set the connection information for a SQL Anywhere reference database.

   • Otherwise, you can also open previous changes written to the *.uag file you have created for that purpose by choosing Read Output From Previous Wizard Session and then clicking Browse.

7. Depending on the source you have selected, follow the instructions in the wizard and validate all SQL statements. Invalid statements have a red × next to the statement name. For a complete reference for each supported statement in UltraLite, see UltraLite SQL Statement Reference.

   To correct invalid SQL statements:

   1. Select an invalid statement.

   2. Correct the statement in the text box provided.

   3. Click Validate All SQL Statements.

   If the statement is validated, it is placed at the bottom of the list and has a green checkmark next to the statement name. Click Cancel at any time to save your changes to the .uag file and exit the wizard.