Partilhar via

Como implementar as bases de dados App-V com scripts SQL

Aplica-se ao Windows Server 2016

Utilize as seguintes instruções para utilizar scripts SQL, em vez do Windows Installer, para:

  • Instalar as bases de dados app-V
  • Atualizar as bases de dados app-V para uma versão posterior

Observação

Se já tiver implementado uma base de dados App-V 5.0 SP3 ou posterior, os scripts SQL não são necessários para atualizar para o App-V para Windows.

Como instalar as bases de dados App-V com scripts SQL

  1. Antes de instalar os scripts da base de dados, reveja e guarde uma cópia dos termos de licenciamento do App-V. Ao executar os scripts da base de dados, está a concordar com os termos de licenciamento. Se não as aceitar, não deve utilizar este software.

  2. Copie appv_server_setup.exe do suporte de dados de versão do App-V para uma localização temporária.

  3. Numa linha de comandos, execute appv_server_setup.exe e especifique uma localização temporária para extrair os scripts da base de dados.

    appv\_server\_setup.exe /layout c:\\_<temporary location path>_

  4. Navegue para a localização temporária que criou, abra a pasta DatabaseScripts extraída e reveja o ficheiro dereadme.txt adequado para obter instruções:

    Banco de dados Localização do ficheiro readme.txt a utilizar
    Base de dados de gestão Subpasta ManagementDatabase
    Base de dados de relatórios Subpasta ReportingDatabase

Cuidado

O ficheiro readme.txt na subpasta ManagementDatabase está desatualizado. As informações nos ficheiros readme atualizados abaixo são as mais recentes e devem substituir as informações de readme fornecidas nas pastas DatabaseScripts .

Importante

O script InsertVersionInfo.sql não é necessário para versões da base de dados de gestão app-V posteriores ao App-V 5.0 SP3.

Conteúdo do ficheiro README da base de dados de gestão atualizada

***********************************************************************************************************
Before you install and use the Application Virtualization Database Scripts, you must:

- Review the license terms.
- Print and retain a copy of the license terms for your records.

By running the App-V 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

Conteúdo do ficheiro README da base de dados de relatórios atualizado

***********************************************************************************************************
Before you install and use the Application Virtualization Database Scripts, you must:

- Review the license terms.
- Print and retain a copy of the license terms for your records.

By running the App-V 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
    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
    Permissions.sql
    ScheduleReportingJob.sql