AdminStudio 2013 R2 | Application Manager
Edition: Application Manager is included with AdminStudio Professional and Enterprise Editions.
Typically, users with administrative privileges in AdminStudio use New on the Application Manager Tab Menu to create a new Application Catalog.
However, because of security concerns, some database administrators may be hesitant to grant the database creation rights that are necessary to create an Application Catalog database using SQL Server to AdminStudio users. Consequently, the database administrator must manually create the database using scripts and provide the necessary read and write access for users to that database. AdminStudio is shipped with database creation SQL scripts to make it easy for database administrators to manually create new Application Catalogs.
| • | Scripts to Run |
| • | Creating an Application Catalog Using Scripts |
When creating an Application Catalog database using scripts, you need to execute both standard scripts and scripts for AdminStudio plug-ins:
| • | Standard Scripts |
| • | Plug-In Scripts |
AdminStudio is shipped with the following database creation SQL scripts:
|
AMS_System_Schema.SQL WFM_System_Data.SQL AMSCreateIndex.SQL WFM_SampleTemplates.SQL AS_System_Schema.SQL AS_ApplicationModel.SQL OsSecurityPatch.SQL MergeModule.SQL PredeploymentTest.SQL SystemManagementServer.SQL WFM_JobManager.SQL AS_TestCenter_Schema.SQL Seed_Data.SQL AS_ApplicationModelSeedData.SQL AS_TestCenter_SeedData.SQL CustomReportWizard.SQL AS_StoredProcedures.SQL VirtualizationReadiness.SQL GroupPackageTree.SQL AS_TestCenter_StoredProcedures.SQL Reporting.StoredProcedures.SQL ApplicationExtendedAttributes.SQL |
These SQL scripts are located in the following directory:
AdminStudio Installation Directory\Support\SQL_Scripts
Note: You can also find the list of the standard scripts that you are required to run to create a new database in the following nodes of the upgrade.xml file (in the AdminStudio Support folder):
//AdminStudioUpgrade/WorkflowManager/Create/SQLServer
//AdminStudioUpgrade/AdminStudio/Create/SQLServer
In addition to the scripts located in the Support\SQL_Scripts directory, you also need to run any SQL script files that are found in the ConflictSolver\Plugins directory. Because AdminStudio provides extensible plug-in functionality, the list of SQL scripts in this directory is not fixed. However, the following table lists the plug-in scripts that are shipped with the product:
|
AppV.SQL Msi.SQL WebApp.SQL XenApp.SQL Xpf.SQL |
Important: The order in which these scripts are run is not important; however, they must be run after the set of scripts listed in Standard Scripts.
Creating an Application Catalog Using Scripts
To create an Application Catalog database on SQL Server, perform the following steps:
To use scripts to create an AdminStudio Application Catalog on SQL Server:
| 1. | Log on to your SQL Server. |
| 2. | Launch the Enterprise Manager and Query Analyzer. |
| 3. | In Query Analyzer, execute a CREATE DATABASE command to create and identify the new Application Catalog database. |
| 4. | Select the newly created database in Query Analyzer. |
| 5. | Execute the following scripts in this order: |
AMS_System_Schema.SQL
WFM_System_Data.SQL
AMSCreateIndex.SQL
WFM_SampleTemplates.SQL
AS_System_Schema.SQL
AS_ApplicationModel.SQL
OsSecurityPatch.SQL
MergeModule.SQL
PredeploymentTest.SQL
SystemManagementServer.SQL
WFM_JobManager.SQL
AS_TestCenter_Schema.SQL
Seed_Data.SQL
AS_ApplicationModelSeedData.SQL
AS_TestCenter_SeedData.SQL
CustomReportWizard.SQL
GroupPackageTree.SQL
VirtualizationReadiness.SQL
AS_StoredProcedures.SQL
AS_TestCenter_StoredProcedures.SQL
Reporting.StoredProcedures.SQL
ApplicationExtendedAttributes.SQL
| 6. | Execute all of the SQL scripts found in the ConflictSolver\Plugins directory. By default, the following scripts are found in the Plugins directory: |
AppV.SQL
Msi.SQL
WebApp.SQL
XenApp.SQL
Xpf.SQL
AdminStudio 2013 R2 Help LibraryNovember 22, 2013 |
Copyright Information | Contact Us |