通过

如何使用 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 Server

如何部署 App-V 5.1 Server