Creating New Application Catalogs Using Scripts
AdminStudio 2023 R2 SP1 | 26.01 | 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 Catalog 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
AS_UI_Support.sql
GroupPackageTree.sql
AS_TestCenter_StoredProcedures.sql
Reporting.StoredProcedures.sql
ApplicationExtendedAttributes.sql
MobileTables.sql
MobileProgrammability.sql
MobileSeedData.sql
DAR_Schema.sql
AS_ShimDB_Schema.sql
AS_ShimDB_SeedData.sql
These SQL scripts are located in the following directory:
[AdminStudioInstallDirectory]\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 Common\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:
Airwatch.sql
Altiris.sql
ApkDeepLink.sql
AppV.sql
AppV5Conversion.sql
AppvServer.sql
AutomatedApplicationConverter.sql
Casper.sql
IpaDeepLink.sql
Msi.sql
WebDeploy.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
AS_StoredProcedures.sql
VirtualizationReadiness.sql
AS_UI_Support.sql
GroupPackageTree.sql
AS_TestCenter_StoredProcedures.sql
Reporting.StoredProcedures.sql
ApplicationExtendedAttributes.sql
MobileTables.sql
MobileProgrammability.sql
MobileSeedData.sql
DAR_Schema.sql
AS_ShimDB_Schema.sql
AS_ShimDB_SeedData.sql
| 6. | Execute all of the SQL scripts found in the Common\Plugins directory. By default, the following scripts are found in the Plugins directory: |
Airwatch.sql
Altiris.sql
ApkDeepLink.sql
AppV.sql
AppV5Conversion.sql
AppvServer.sql
AutomatedApplicationConverter.sql
Casper.sql
IpaDeepLink.sql
Msi.sql
WebDeploy.sql
XenApp.sql
Xpf.sql