程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase綜合文章 >> 教你學會怎樣升級到SQL Anywhere 10(7)

教你學會怎樣升級到SQL Anywhere 10(7)

編輯:SyBase綜合文章

升級SQL Anywhere 統一數據庫

1、 如果您要升級SQL Anywhere 統一數據庫,請先將數據庫升級至版本10:

a. 關閉數據庫服務器

b. 升級數據庫至版本10

c. 啟動數據庫服務器,以DBA 登錄

2、 如果從版本6.x 升級,則需運行位於SQL Anywhere 安裝目錄下MobiLink\setup 子目錄的

MobiLink 設置腳本。如果從一個更新的版本升級,則不需運行設置腳本。

3、 運行適當的升級腳本。

升級腳本名為upgrade_asa.sql。他們位於SQL Anywhere 安裝目錄下的

MobiLink\upgrade\version,version 是升級前的SQL Anywhere 版本。

要運行升級腳本,必須模擬為DBO 用戶,可使用SETUSER SQL 語句來實現。

例如,升級版本9.0.2 的SQL Anywhere 統一數據庫,使用Interactive SQL 連接至數據庫

並運行以下命令:

SETUSER "dbo";

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

4、 去除DBO 密碼。例如:

GRANT CONNECT TO "dbo"

5、 如果以非DBA 用戶啟動MobiLink 服務器,則必須授予該用戶執行新MobiLink 系統對象的

權限。以下代碼授予了對所有MobiLink 系統對象的必要權限。在執行這些代碼之前,您必

須將代碼中的my_user 替換成啟動MobiLink 服務器的用戶。

 

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_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;
  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved