sybase sql anywhere upgrade database...펌

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

SQL Anywhere 12.0.0 » SQL Anywhere 12 - Changes and Upgrading » Upgrading to SQL Anywhere 12

 

Upgrading SQL Anywhere

Before using existing applications with this version of the software, be sure to review the list of behavior changes to determine whether your application is affected. See SQL Anywhere 12 - Changes and Upgrading.

 Upgrading version 10 and later databases

If you are upgrading from version 10 or later, you can either upgrade or rebuild your database. Upgrading or rebuilding is an optional step because the version 12 software can be used with a version 10 or later database. However, if you want to take advantage of all the new features in version 12, you must rebuild your database. See Upgrading version 10 and later databases and Rebuilding version 10 and later databases.

Databases with materialized views

It is recommended that you refresh the materialized views in your database after upgrading your database server, or after rebuilding or upgrading your database to work with an upgraded database server. See Refresh manual views.

 Upgrading version 9 and earlier databases

If you are upgrading to version 12 from version 9 or earlier, you must rebuild the database, which consists of unloading the old database, and reloading it into a new version 12 database. Attempting to start version 9 or earlier databases results in an error on database startup. There are several approaches for rebuilding existing databases:

• Use the version 12 Unload utility (dbunload) with the -an (create a new database) or -ar (replace the old database) option. See Rebuild a version 9 or earlier database using the Unload utility.

  Note

  The Unload utility (dbunload) has the same file name in all versions of SQL Anywhere. You must make sure you are using the correct version. Run the command dbunload -? to determine which version of the Unload utility you are using. See Using the utilities.

• Unload the database using the version 12 Unload utility, and then reload the database using the reload.sql file on the version 12 database server.

  If you need to make schema changes, this is the recommended way of upgrading. After you make the schema changes, you can create a new database, and then apply the reload script to it.

• Use the Unload Database Wizard in Sybase Central. You can choose to create a new database, replace an existing database with the new database, or unload the database to a file. See Rebuild a version 9 or earlier database from Sybase Central.

• Unload the database using an older version of dbunload, and then reload the database using the reload.sql file and the version 12 database server. You should only use this approach if the other methods fail because deprecated or unsupported database option settings, objects, or SQL syntax could be unloaded into the reload.sql file. You must edit the file manually if problems occur during the reload. The internal reload capabilities of version 12 take care of many of these problems.

Rebuilding Mac OS X databases

SQL Anywhere 9.0.2 for Mac OS X was supported on PPC, while SQL Anywhere 10 and later for Mac OS X are supported on Intel. If you have a version 9.0.2 or earlier database on Mac OS X, you have two options for unloading the database:

• Unload the database using the version 9.0.2 software.

• Copy the database to a different platform where SQL Anywhere 12 is installed, and then unload the database using the version 12 software.

Once the database is unloaded, you can perform the reload on Mac OS X using the version 12 software.

If you want to change the characteristics of the database during unload and reload (for example, change a case-sensitive database to a case-insensitive database), the procedure is more involved. See Rebuilding databases.

 Compatibility with existing software

• SQL Anywhere 12 database servers support connections from client applications using software from version 6.0.0 or later. Version 5 and earlier clients cannot connect to a version 12 database server.

• You can manage old databases and old database servers from the current version of Sybase Central as follows:

  • You can connect to and administer version 10 and later databases running on version 10 and later database servers.

  • You can connect to a version 5 or later database running on the same computer as Sybase Central to rebuild the database using the Unload Database Wizard from Sybase Central. The database is stopped before it is unloaded.

  • There is no support for version 9 and earlier databases running on version 9 and older database servers.

---

Using the utilities
Important upgrade precautions
Upgrade quick start
Rebuilding version 10 and later databases
Rebuilding version 9 and earlier databases for version 12
Upgrading version 10 and later databases