AdminStudio 11.5 | Application Manager
Edition: Application Manager is included with AdminStudio Professional and Enterprise Editions.
Typically, users with administrative privileges in AdminStudio use Create on the Catalog menu (or 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 create new Application Catalogs:
Script File |
Description |
AMS_System_Schema.SQL |
Primary Workflow Manager tables |
WFM_System_Data.SQL |
Default company template users and roles |
AMSCreateIndex.SQL |
Indexes for Workflow Manager tables |
WFM_SampleTemplates.SQL |
Sample Workflow Manager template data |
AS_System_Schema.SQL |
Primary AdminStudio client tools data |
Seed_Data.SQL |
Seed data required by AdminStudio |
CustomReportWizard.SQL |
Report Center data |
AS_TestCenter.SQL |
Creates various stored procedures for generating Test Center results |
AS_TestEngine.SQL |
Creates the tables for Test Center, and populates the tests provided by Test Center in the AdminStudio Application Catalog |
Reporting.StoredProcedures.SQL |
Application Catalog enhanced reporting data |
These SQL scripts are located in the following directory:
AdminStudio Installation Directory\Support\SQL_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 order: |
a. | AMS_System_Schema.SQL |
b. | WFM_System_Data.SQL |
c. | AMSCreateIndex.SQL |
d. | WFM_SampleTemplates.SQL |
e. | AS_System_Schema.SQL |
f. | Seed_Data.SQL |
g. | CustomReportWizard.SQL |
h. | AS_TestCenter.SQL |
i. | AS_TestEngine.SQL |
j. | Reporting.StoredProcedures.SQL |
Note: You can also find the list of the 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
Note: To see a list of the scripts that you are required to run to upgrade an existing database, view the following nodes of the upgrade.xml file (in the AdminStudio Support folder):
//AdminStudioUpgrade/WorkflowManager/Upgrades/Upgrade/SQLServer
//AdminStudioUpgrade/AdminStudio/Upgrades/Upgrade/SQLServer
AdminStudio 11.5 Help LibraryJuly 9, 2012 |
Copyright Information | Contact Us |