Utility versions and the upgrade process

If you have multiple versions of SQL Anywhere on your Windows computer, you must pay attention to your system path when using utilities. Since the installation adds the most recently installed version executable directory to the end of your system path, it is possible to install a new version of the software, and still inadvertently be running the previously installed version.

For example, if a SQL Anywhere version 8 executable directory is ahead of the SQL Anywhere 12 executable directory in your path and you use the dbinit command, you will use the version 8 utility, and consequently create a version 8 database.

There are several ways you can ensure that you are using the version 12 utilities, including:

  • Modify your system path so that the SQL Anywhere 12 executable directory is before any previous version executable directory.

  • Change to the SQL Anywhere 12 executable directory before running your command.

  • Specify a fully-qualified path name to the utility name that indicates the exact location of the utility you want to run.

  • Create scripts to change your environment to use the correct version of the utilities.

  • Uninstall the old software.