|Summary: this page describes how to migrate CAST AIP schemas installed on Oracle Server and Microsoft SQL Server instances over to CAST Storage Service (CSS) / PostgreSQL.|
If you have installed your CAST AIP schemas (Analysis/Dashboard/Management Services) on a commercial RDBMS such as Oracle Server or Microsoft SQL Server and you wish to migrate these existing schemas to CSS then CAST Storage Service / PostgreSQL then CAST has created a tool specifically to do this for you. The tool will:
- migrate a triplet of CAST AIP schemas (Analysis/Dashboard/Management Services) and their entire contents to CSSto CAST Storage Service / PostgreSQL
- migrate one single CAST AIP schema and its entire contents to CSSto CAST Storage Service / PostgreSQL
You can use the tool in GUI mode, or in CLI mode. Each mode is explained below.
The tool relies on the presence of an XML based configuration file (called configuration.castmigration) which provides the "instructions" about what needs to be migrated and configured the source RDBMS and target CSSCAST Storage Service / PostgreSQL. This needs to be created before using the tool.
The tool supports the migration of any type of CAST AIP schema (Analysis / Dashboard / Management Services) installed on an Oracle Server or Microsoft SQL Server with CAST AIP 7.0.x and above to a CAST a CAST Storage Service (CSS)/ PostgreSQL.
Supported CAST Storage Services/PostgreSQL
|CSS 1 / PostgreSQL 8.4.x|
|CSS2 / PostgreSQL 9.2.x|
|CSS 3 / PostgreSQL 9.6.x|