共用方式為

如何使用 SQL 指令碼部署 App-V 資料庫

  • 發行項

使用下列指示來使用 SQL 腳本，而非 Windows Installer，以：

  • 安裝 App-V 5.1 資料庫
  • 將 App-V 資料庫升級至更新版本

注意

如果您已部署 App-V 5.0 SP3 資料庫，則不需要 SQL 腳本即可升級至 App-V 5.1。

如何使用 SQL 腳本安裝 App-V 資料庫

  1. 安裝資料庫腳本之前，請先檢閱並保留 App-V 授權條款的複本。 藉由執行資料庫腳本，您即同意授權條款。 如果您不接受它們，就不應該使用此軟體。

  2. appv_server_setup.exe將 從 App-V 發行媒體複製到暫存位置。

  3. 從命令提示字元中，執行 appv_server_setup.exe 並指定擷取資料庫腳本的暫存位置。

    例子： appv_server_setup.exe /layout c:\<temporary location path>

  4. 流覽至您建立的暫存位置、開啟解 DatabaseScripts 壓縮的資料夾，並檢閱適當的 Readme.txt 檔案以取得指示：

    • 管理資料庫： ManagementDatabase 子資料夾

    • 報表資料庫： ReportingDatabase 子資料夾

注意

子資料夾中的 ManagementDatabase readme.txt 檔案已過期。 下方更新的讀我檔案中的資訊是最最新的，應該取代資料夾中 DatabaseScripts 提供的讀我檔案資訊。

重要

App-V 5.0 SP3 之後的 App-V 管理資料庫版本不需要 InsertVersionInfo.sql 腳本。

已更新管理資料庫讀我檔案內容

******************************************************************
Before you install and use the Application Virtualization Database Scripts you must:
1.Review the Microsoft Application Virtualization Server 5.0 license terms.
2.Print and retain a copy of the license terms for your records.
By running the Microsoft Application Virtualization Database Scripts you agree to such license terms.  If you do not accept them, do not use the software.
******************************************************************


Steps to install "AppVManagement" schema in SQL SERVER.


## PREREQUISITES:

 1. Review the installation package.  The following files MUST exist:

    SQL files
    ---------
    Database.sql
    CreateTables.sql
    CreateStoredProcs.sql
    UpdateTables.sql
    Permissions.sql

 2. Ensure the target SQL Server instance and SQL Server Agent service are running.

 3. If you are not running the scripts directly on the server, ensure the
    necessary SQL Server client software is installed and available from
    the specified location.  Specifically, the "osql" command must
##     be supported for these scripts to run.



## PREPARATION:

 1. Review the database.sql file and modify as necessary.  Although the
    defaults are likely sufficient, it is suggested that the following
    settings be reviewed:

    DATABASE - ensure name is satisfactory - default is "AppVManagement".

 2. Review the Permissions.sql file and provide all the necessary account information
    for setting up read and write access on the database. Note: Default settings
##     in the file will not work.



## INSTALLATION:

 1. Run the database.sql against the "master" database.  Your user
    credential must have the ability to create databases.
    This script will create the database.

 2. Run the following scripts against the "AppVManagement" database using the
    same account as above in order.

    CreateTables.sql
    CreateStoredProcs.sql
    UpdateTables.sql
##     Permissions.sql

已更新報告資料庫讀我檔案內容

******************************************************************
Before you install and use the Application Virtualization Database Scripts you must:
1.Review the Microsoft Application Virtualization Server 5.0 license terms.
2.Print and retain a copy of the license terms for your records.
By running the Microsoft Application Virtualization Database Scripts you agree to such license terms.  If you do not accept them, do not use the software.
******************************************************************

Steps to install "AppVReporting" schema in SQL SERVER.


## PREREQUISITES:

 1. Review the installation package.  The following files MUST exist:

    SQL files
    ---------
    Database.sql
    UpgradeDatabase.sql
    CreateTables.sql
    CreateReportingStoredProcs.sql
    CreateStoredProcs.sql
    CreateViews.sql
    InsertVersionInfo.sql
    Permissions.sql
    ScheduleReportingJob.sql

 2. Ensure the target SQL Server instance and SQL Server Agent service are running.

 3. If you are not running the scripts directly on the server, ensure the
    necessary SQL Server client software is installed and executable from
    the location you have chosen.  Specifically, the "osql" command must
##     be supported for these scripts to run.



## PREPARATION:

 1. Review the database.sql file and modify as necessary.  Although the
    defaults are likely sufficient, it is suggested that the following
    settings be reviewed:

    DATABASE - ensure name is satisfactory - default is "AppVReporting".

 2. Review the Permissions.sql file and provide all the necessary account information
    for setting up read and write access on the database. Note: Default settings
    in the file will not work.

 3. Review the ScheduleReportingJob.sql file and make sure that the stored proc schedule
    time is acceptable. The default stored proc schedule time is at 12.01 AM (line 84).
    If this time is not suitable, you can change this to a more suitable time. The time is
##     in the format HHMMSS.



## INSTALLATION:

 1. Run the database.sql against the "master" database.  Your user
    credential must have the ability to create databases.
    This script will create the database.

 2. If upgrading the database, run UpgradeDatabase.sql This will upgrade database schema.

 2. Run the following scripts against the "AppVReporting" database using the
    same account as above in order.

    CreateTables.sql
    CreateReportingStoredProcs.sql
    CreateStoredProcs.sql
    CreateViews.sql
    InsertVersionInfo.sql
    Permissions.sql
##     ScheduleReportingJob.sql

部署 App-V 5.1 伺服器

如何部署 App-V 5.1 Server