To upgrade an existing UltraLite database or schema, choose one of the following options:
Upgrade A Database Wizard Choose the wizard if you want to be guided through the process and have help choosing available properties/options. Before completing the instructions in the Upgrade A Database Wizard 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 to apply the schema of the old database to the new database.
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.
Complete the standard precautions for upgrading software, including backing up the database. See Important upgrade precautions.
Choose Start » Programs » SQL Anywhere 11 » Sybase Central.
Choose Tools » UltraLite 11 » Upgrade Database.
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).
Specify the connection parameters and then click Next.
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.
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.
Carry out the standard precautions for upgrading software, including backing up the database. See Important upgrade precautions.
Ensure that the 11.0.0 version of UltraLite utilities are ahead of older UltraLite utilities in your system path. See Using the utilities.
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).
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
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|