教你学会怎样升级到SQL Anywhere 10（7）

新客网 XKER.COM 2007-08-16 来源： 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;

上一篇：教你学会怎样升级到SQL Anywhere 10（6）下一篇：教你学会怎样升级到SQL Anywhere 10（8）

【收藏】【评论】【推荐】【投稿】【打印】【关闭】