Upgrading an Application Catalog Manually Using Scripts
Rather than opening an Application Catalog in the AdminStudio user interface, you can use scripts to upgrade an existing database.
Important:This is an advanced method of upgrading a database which requires running scripts manually on a database server.
To upgrade an existing Application Catalog database:
| 1. | Open the CSSYSSCHEMAINFO table of your existing Application Catalog database, and locate the record with the highest SchemaVersion value. This is the SchemaVersion that you are upgrading from. |
| 2. | Locate the same SchemaVersion number in the table below, and note the corresponding Product Version number. |
| 3. | Run all of the scripts listed in the Scripts to Run column for that Product Version, in order. |
| 4. | Next, run all of the scripts listed in the Scripts to Run column for subsequent product versions. If a script listed in a subsequent product version has already been run, it does not need to be run again. |
For example, if you are upgrading from SchemaVersion 13286609, first run all of the scripts in the 14.0 row of the table, and then run all of the scripts in the 14.01 row of the table that have not already been run.
|
Product Version (SchemaVersion) Upgrading From |
Product Version Upgrading To |
Scripts to Run |
|
12.00 (13286602) |
12.01 |
1201Upgrade.sql |
|
12.01 (13286603) |
12.02 |
DarwinFixes.sql 1202Upgrade.sql 1202UpgradeWFM.sql 1202UpgradeWFMEmailTemplate1.sql 1202UpgradeWFMEmailTemplate2.sql |
|
12.02 (13286605) |
13.00 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.sql CustomReportWizard.sql AS_StoredProcedures.sql VirtualizationReadiness.sql GroupPackageTree.sql AS_TestCenter_StoredProcedures.sql Reporting.StoredProcedures.sql ApplicationExtendedAttributes.sql MobileTables.sql MobileProgrammability.sql 1300Upgrade.sql MobileSeedDataEUCLID.sql 1301UpgradeWFM.sql 1302UpgradeWFM.SQL You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts are shipped with the product: AirWatch.sql Altiris.sql AppV.sql AppvServer.sql Msi.sql XenApp.sql Xpf.sql |
|
13.00 (13286607) |
14.00 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.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 1400Upgrade.sql DARSchemaUpdate.sql You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts are shipped with the product: AirWatch.sql Altiris.sql AppV.sql AppvServer.sql Msi.sql XenApp.sql Xpf.sql |
|
14.0 (13286609) |
14.01 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.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 AS_ShimDB_Schema.sql AS_ShimDB_SeedData.sql 1401Upgrade.sql 1401UpgradeWFM.sql 1401UpgradeAIR.sql 1401UpgradeAIRProjectData.sql You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts are shipped with the product: AirWatch.sql Altiris.sql AppV.sql AppvServer.sql Msi.sql WebDeploy.sql XenApp.sql Xpf.sql |
|
14.01 (13286611) |
15.00 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.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 1500Upgrade.sql 1500UpgradeWFM.sql 1500UpgradeAIR.sql You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts 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 |
|
15.0 (13286613) |
15.01 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.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 AS_ShimDB_Schema.sql AS_ShimDB_SeedData.sql 1500UpgradeGalileoFix.sql 1501Upgrade.sql 1501UpgradeWFM.sql 1500UpgradeGalileoAIRFix.sql 1501UpgradeAIR.sql You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts 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 |
|
15.01 (13286615) |
15.02 |
AS_System_Schema.sql AS_ApplicationModel.sql OsSecurityPatch.sql MergeModule.sql PredeploymentTest.sql SystemManagementServer.sql WFM_JobManager.sql AS_TestCenter_Schema.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 AS_ShimDB_Schema.sql AS_ShimDB_SeedData.sql 1502Upgrade.xml You also need to run any SQL scripts that are found in the Common\Plugins directory. The following plug-in scripts 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:All of the information in this table can be found in the Upgrade.xml file, which is installed in the Support subdirectory of the AdminStudio installation directory. This file also includes information on upgrading from versions prior to version 12.0 (AdminStudio 2013).