Como implantar os bancos de dados do App-V usando scripts SQL
Aplica-se ao Windows Server 2016
Use as seguintes instruções para usar scripts SQL, em vez do Instalador do Windows, para:
- Instalar os bancos de dados do App-V
- Atualizar os bancos de dados do App-V para uma versão posterior
Observação
Se você já implantou um banco de dados SP3 do App-V 5.0 ou posterior, os scripts SQL não serão necessários para atualizar para o App-V para Windows.
Como instalar os bancos de dados do App-V usando scripts SQL
Antes de instalar os scripts do banco de dados, examine e mantenha uma cópia dos termos de licença do App-V. Ao executar os scripts de banco de dados, você está concordando com os termos de licença. Se você não as aceitar, não deverá usar esse software.
Copie appv_server_setup.exe da mídia de versão do App-V para um local temporário.
Em um prompt de comando, execute appv_server_setup.exe e especifique um local temporário para extrair os scripts de banco de dados.
appv\_server\_setup.exe /layout c:\\_<temporary location path>_Navegue até o local temporário que você criou, abra a pasta DatabaseScripts extraída e examine o arquivo readme.txt apropriado para obter instruções:
Banco de dados Local do arquivo readme.txt a ser usado Banco de dados de gerenciamento Subpastabase ManagementDatabase Banco de dados de relatórios Subpastabase ReportingDatabase
Cuidado
O arquivo readme.txt na subpasta de ManagementDatabase está desatualizado. As informações nos arquivos readme atualizados abaixo são as mais atuais e devem substituir as informações de readme fornecidas nas pastas DatabaseScripts .
Importante
O script InsertVersionInfo.sql não é necessário para versões do banco de dados de gerenciamento do App-V posteriores ao App-V 5.0 SP3.
Conteúdo do arquivo README do banco de dados de gerenciamento 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 "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 arquivo README do banco 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