Teach you how to upgrade to SQL Anywhere 10 (8)

Source: Internet
Author: User
Tags copy db2 microsoft sql server connect

Upgrade Adaptive Server Enterprise, Oracle, or Microsoft SQL Server databases

1. If you upgrade from version 6.x, you need to run the Mobilink setup script that is located in the Mobilink\setup subdirectory under the SQL Anywhere installation directory. If you upgrade from an updated version, you do not need to run the setup script.

2, run the appropriate upgrade script.

The upgrade pin name is upgrade_xxx.sql,xxx the type of the consolidated database. Their mobilink\upgrade\version,version in the SQL Anywhere installation directory is the version of SQL anywhere before the upgrade.

For example:

READ 'c:\Program Files\SQL Anywhere
10\MobiLink\upgrade\902\upgrade_asa.sql'

Upgrading the DB2 Database

1. Copy the Mobilink\setup\syncdb2long.class file to the Sqllib\function directory of the computer where the DB2 server resides. You may have to restart the DB2 instance.

2. If you are upgrading from Mobilink version 6, you will need to run

MobiLink\setup\syncdb2long.sql

Set up SQL scripts to create Mobilink system tables and stored procedures.

3, positioning DB2 upgrade script.

The upgrade foot name is:

upgrade_db2tolong.sql

A mobilink/upgrade/version subdirectory located in the SQL Anywhere installation directory. Version represents the versions of Mobilink before the upgrade.

4, copy and modify the Upgrade_db2tolong.sql file. Modify the Connect statement at the beginning of the file to the instance you want to connect to. Apply this SQL script to the consolidated database.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.