Skip to main content

Creating New Application Catalogs Using Scripts

AdminStudio 2025 R2 | 30.0 | Application Manager

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​

When creating an Application Catalog database using scripts, you need to execute both standard scripts and scripts for AdminStudio plug-ins:

Standard 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

Plug-In Scripts​

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
note

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