Before you can use the new MobiLink server with an existing consolidated database, you must run upgrade scripts that install new system objects. The upgrade scripts must be run by the owner of the currently installed MobiLink system tables.

Notes

Upgrading SQL Anywhere version 10.0.0 and later

To upgrade a consolidated database (SQL Anywhere 10.0.0 and later)

1. Upgrade the SQL Anywhere database.

   See Upgrading version 10 and later databases.

2. Run the appropriate upgrade script for the version you are upgrading from.

   The upgrade script is called upgrade_sa.sql. It is located under your SQL Anywhere installation in MobiLink\upgrade\version, where version is the SQL Anywhere version you are upgrading from.

   For example, connect to the database in Interactive SQL and run the following command:

   READ "c:\Program Files\SQL Anywhere 11\MobiLink\upgrade\10.0.1\upgrade_sa.sql"

Upgrading SQL Anywhere prior to version 10.0.0

To upgrade a consolidated database (SQL Anywhere earlier than 10.0.0)

1. If you are upgrading a SQL Anywhere consolidated database that is earlier than version 10.0.0, you must first upgrade the database to version 11:

   1. Shut down the database server.

   2. Upgrade the database to version 11.

      For instructions, see:

      • Upgrading version 10 and later databases
      • Rebuilding version 10 and later databases
      • Rebuilding version 9 and earlier databases for version 11

   3. Start the database server, logging in as DBA.

      You must log in as DBA to upgrade.

2. If you are upgrading from version 6.0.x, run the MobiLink setup script, located in the MobiLink\setup subdirectory of your SQL Anywhere installation directory. Do not run the setup script if you are upgrading from a later version.

   For more information about setup scripts, see MobiLink consolidated databases.

3. Run the appropriate upgrade script for the version you are upgrading from.

   The upgrade script is called upgrade_asa.sql. It is located under your SQL Anywhere installation in MobiLink\upgrade\version, where version is the SQL Anywhere version you are upgrading from.

   To run the upgrade scripts, you must impersonate the dbo user. You can do this with the SETUSER SQL statement.

   For example, to upgrade a SQL Anywhere version 9.0.2 consolidated database, connect to the database in Interactive SQL and run the following command:

   SETUSER "dbo"; READ 'c:\Program Files\SQL Anywhere 11\MobiLink\upgrade\9.0.2\upgrade_asa.sql'

4. Remove the dbo password. For example:

   GRANT CONNECT TO "dbo";

5. If you are running the MobiLink server as a user other than DBA, you must grant execute permission for that user on the new MobiLink system objects. Which system objects are new depends on which version you are upgrading from. The following code grants the necessary permissions to all MobiLink system objects. Before executing the code, you must change the user name my_user to the name of the user who is running the MobiLink server.

   GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_column to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_connection_script to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_database to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_device to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_device_address to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_listening to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_property to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_clients to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_delivery to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_global_props to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_notifications to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_repository to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_repository_props to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_repository_staging to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_status_history to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_status_staging to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_script to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_script_version to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_scripts_modified to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_server to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_active_remote_id to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_passthrough_script to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_passthrough to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_passthrough_status to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_passthrough_repair to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_repository_archive to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_delivery_archive to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_status_history_archive to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_qa_repository_props_archive to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_sis_sync_state to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_subscription to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_table to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_table_script to my_user; GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.ml_user to my_user; GRANT EXECUTE ON dbo.ml_qa_get_agent_network_property to my_user; GRANT EXECUTE ON dbo.ml_qa_get_agent_object_property to my_user; GRANT EXECUTE ON dbo.ml_qa_get_agent_property to my_user; GRANT EXECUTE ON dbo.ml_qa_get_message_property to my_user; GRANT EXECUTE ON dbo.ml_add_column to my_user; GRANT EXECUTE ON dbo.ml_add_connection_script to my_user; GRANT EXECUTE ON dbo.ml_add_dnet_connection_script to my_user; GRANT EXECUTE ON dbo.ml_add_dnet_table_script to my_user; GRANT EXECUTE ON dbo.ml_add_java_connection_script to my_user; GRANT EXECUTE ON dbo.ml_add_java_table_script to my_user; GRANT EXECUTE ON dbo.ml_add_lang_conn_script_chk to my_user; GRANT EXECUTE ON dbo.ml_add_lang_connection_script to my_user; GRANT EXECUTE ON dbo.ml_add_lang_table_script to my_user; GRANT EXECUTE ON dbo.ml_add_lang_table_script_chk to my_user; GRANT EXECUTE ON dbo.ml_add_property to my_user; GRANT EXECUTE ON dbo.ml_add_table_script to my_user; GRANT EXECUTE ON dbo.ml_add_user to my_user; GRANT EXECUTE ON dbo.ml_delete_device to my_user; GRANT EXECUTE ON dbo.ml_delete_device_address to my_user; GRANT EXECUTE ON dbo.ml_delete_listening to my_user; GRANT EXECUTE ON dbo.ml_delete_sync_state to my_user; GRANT EXECUTE ON dbo.ml_delete_sync_state_before to my_user; GRANT EXECUTE ON dbo.ml_delete_user to my_user; GRANT EXECUTE ON dbo.ml_qa_add_delivery to my_user; GRANT EXECUTE ON dbo.ml_qa_add_message to my_user; GRANT EXECUTE ON dbo.ml_qa_handle_error to my_user; GRANT EXECUTE ON dbo.ml_qa_stage_status_from_client to my_user; GRANT EXECUTE ON dbo.ml_qa_staged_status_for_client to my_user; GRANT EXECUTE ON dbo.ml_qa_upsert_global_prop to my_user; GRANT EXECUTE ON dbo.ml_reset_sync_state to my_user; GRANT EXECUTE ON dbo.ml_set_device to my_user; GRANT EXECUTE ON dbo.ml_set_device_address to my_user; GRANT EXECUTE ON dbo.ml_set_listening to my_user; GRANT EXECUTE ON dbo.ml_set_sis_sync_state to my_user; GRANT EXECUTE ON dbo.ml_upload_update_device_address to my_user; GRANT EXECUTE ON dbo.ml_upload_update_listening to my_user; GRANT EXECUTE ON dbo.ml_server_update to my_user; GRANT EXECUTE ON dbo.ml_server_delete to my_user; GRANT EXECUTE ON dbo.ml_add_passthrough_script to my_user; GRANT EXECUTE ON dbo.ml_add_passthrough to my_user; GRANT EXECUTE ON dbo.ml_add_passthrough_repair to my_user; GRANT EXECUTE ON dbo.ml_delete_passthrough_script to my_user; GRANT EXECUTE ON dbo.ml_delete_passthrough to my_user; GRANT EXECUTE ON dbo.ml_delete_passthrough_repair to my_user;

Upgrading Adaptive Server Enterprise, Oracle, or Microsoft SQL Server MobiLink system tables

You only need to upgrade the MobiLink system objects in your Adaptive Server Enterprise, Oracle, or Microsoft SQL Server consolidated database if your version of the MobiLink server is earlier than version 11.0.0.

To upgrade a consolidated database (Adaptive Server Enterprise, Oracle, or Microsoft SQL Server)

1. If you are upgrading from version 6.0.x, run the MobiLink setup script, located in the MobiLink\setup subdirectory of your SQL Anywhere installation. Do not run the setup script if you are upgrading from a later version.

   For more information about setup scripts, see MobiLink consolidated databases.

2. For Adaptive Server Enterprise databases, you must set "select into" permission. Run the following command in Sybase Interactive SQL:

   USE MASTER go sp_dboption your-database-name, "SELECT INTO", true go USE your-database-name go checkpoint go

3. Run the appropriate upgrade script for the version you are upgrading from.

   The upgrade scripts are called upgrade_XXX.sql, where XXX indicates the RDBMS of your consolidated database. They are located under your SQL Anywhere installation in MobiLink\upgrade\version, where version is the MobiLink version you are upgrading from.

   For example, to upgrade a Microsoft SQL Server version 9.0.2 consolidated database, run the following command:

   isql -S server_name -U user_name -P password -I "c:\Program Files\SQL Anywhere 11\MobiLink\upgrade\9.0.2\upgrade_mss.sql"

Upgrading IBM DB2 LUW

You only need to upgrade your DB2 LUW consolidated database if your version of the MobiLink server is earlier than version 11.0.0.

To upgrade a DB2 LUW consolidated database

1. If you are upgrading from MobiLink version 6, create the MobiLink system tables and stored procedures by running the setup SQL script MobiLink\setup\syncdb2.sql.

   For information about how to run the DB2 LUW setup script, see IBM DB2 LUW consolidated database.

2. Locate the DB2 LUW upgrade script.

   The upgrade script is called upgrade_db2.sql and is held in the MobiLink/upgrade/version subdirectory of your SQL Anywhere installation. The version directory refers to the version of MobiLink from which you are upgrading.

3. Copy upgrade_db2.sql and modify the copy. Change the CONNECT statement at the start of the script so it works with the instance you want to connect to. Apply the copied SQL script to the consolidated database.