Teach you how to upgrade to SQL Anywhere10 (12)

To upgrade an existing Ultralite database to version 10 on the command line

1, please read the important items in the upgrade carefully

2. To ensure that Ultralite version 10 utilities in the system path compare earlier versions of Ultralite utilities in the previous

3. Open the command line terminal and use the following command to run the Uninstall Legacy Database tool (Ulunloadold) to create an intermediate file of XML:

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

Make sure you have:

o Name the XML file that the Ulunloadold utility will create

o use DBF or schema files in the connection string (connection-string), depending on you want to upgrade the Legacy Ultralite database (*.UDB or *.pdb) or the Legacy Ultralite schema file (*.USM).

You can determine other parameters yourself.

4. Execute Load XML Database utility (Ulload) to add XML to a new or existing Ultralite database.

If you want to load the XML into a new database, the-C connection string option is set to the connection parameters for the new database (for example, UID and PWD, and so on).

Sets the-O extension option, depending on whether you change the character set and properties (for example, a case sensitive database to a case insensitive database).

For example, to upgrade an Ultralite 8.x schema file named Dbschema8.usm to an existing Ultralite version 10 database named DB.UDB, the XML intermediate file is named Dbschema.xml. The order is as follows:

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

Initialization/Extraction Tool

You can use the Extract Tool Wizard or the initialization Database utility (Ulinit) to extract an Ultralite database from the SQL anywhere database in version 10.

Remind:

Set the properties of the reference database to the properties that Ultralite requires. The generated Ultralite database is consistent with the properties of the SQL anywhere reference database. By setting these options in the reference database, you can also control the behavior of the Ultralite database.

• If you want to go step-by-Step under the wizard and want help with the properties and options, select the Wizard tool.

• Select a utility if you have the following requirements:

Only need to upgrade the named table in the new database need to implement the batch process

Initializing/Extracting an Ultralite database from the SQL Anywhere reference database in Sybase Central

1, please read carefully the important things in software upgrades.

2, make sure you have upgraded the SQL anywhere database and prepare it based on ultralite usage. If you need to upgrade your publication, be sure to do so before rebuilding the Ultralite database.

3. Start Sybase in "Start" > "program" > "SQL Anywhere" > "Sybase".

4, extract the UltraLite database from the SQL anywhere database by selecting Tools > Ultralite > Extract Database.

5, follow the steps of the wizard to complete initialization/extraction.