Extracting UltraLite databases from version 9 and earlier SQL Anywhere databases

You can extract an UltraLite database from a version 10.0.0 or later 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 want to implement a batch-oriented process.

To initialize/extract an UltraLite database from a version 9 or earlier SQL Anywhere reference database (Sybase Central)

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

  2. Upgrade the SQL Anywhere database and prepare it with UltraLite usage in mind. If you need to update publications, be sure to do so before re-creating the UltraLite database.

    For information about upgrading SQL Anywhere version 9 and earlier databases, see Rebuilding version 9 and earlier databases for version 11.0.0.

  3. Start Sybase Central by choosing Start » Programs » SQL Anywhere 11 » Sybase Central.

  4. Extract an UltraLite version of the SQL Anywhere database by choosing Tools » UltraLite 11 » Extract (ulinit) Database.

  5. Follow the instructions in the Extract Database Wizard.

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

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

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

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

    For information about upgrading SQL Anywhere version 9 and earlier databases, see Rebuilding version 9 and earlier databases for version 11.0.0.

  4. 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 optional.

    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 Choosing database creation parameters for UltraLite.

For a complete reference, see UltraLite Initialize Database utility (ulinit). For more information on UltraLite database properties you can configure, see UltraLite database properties.