...
- migrate a triplet of CAST AIP schemas (Analysis/Dashboard/Management Services) and their entire contents to CSS
- migrate one single CAST AIP schema and its entire contents to CSS2CSS
You can use the tool in GUI mode, or in CLI mode. Each mode is explained below.
...
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="DRIVER_NAME" originServerUrl="URL" targetServerDriverClassName="org.postgresql.Driver" targetServerUrl="jdbc:postgresql://SERVER_NAME_OR_IP_ADDRESS:<2280|2282>/postgres" licenseKey="LICENSE_KEY" forceCSS2Storage="true">
<MBSchema name="MNGT_NAME" skipCustomTables="true|false" state="" isSelected="true|false">
<KBSchema name="LOCAL_NAME" skipCustomTables="true|false" state=""/>
<CBSchema name="CENTRAL_NAME" skipCustomTables="true|false" state=""/>
</MBSchema>
</Configuration> |
<configuration> tag
This tag contains the values needed to connect to the source RDBMS and the target CSS server, the CAST AIP license key and an optional value for those migration schemas from CAST AIP 7.0.x:
| Element | Description | Options | Required | ||||
|---|---|---|---|---|---|---|---|
originServerDriverClassName | Defines the JDBC driver used to connect to the source RDBMS. |
| Yes | ||||
originServerUrl | Defines the URL (in JDBC format) used to connect to the source RDBMS. |
| Yes | ||||
| targetServerDriverClassName | Defines the JDBC driver used to connect to the target CSS2CSS. | org.postgresql.Driver | Yes | ||||
| targetServerUrl | Defines the URL (in JDBC format) used to connect to the target CSS2CSS. | jdbc:postgresql://HOST:<2280|2282>/postgres | Yes | ||||
| licenseKey | Defines the CAST AIP license key assigned to the schemas you wish to migrate. | Full CAST AIP license key in the format: Sample&Test:1;AIP/EFP:20121031:ABCDEFGH | Yes | forceCSS2Storage | Use this option (with "true") if you are migrating schemas installed with CAST AIP 7.0.x. Omit the option entirely if it is not required. | True | Only required when migrating schemas installed with CAST AIP 7.0.x. |
| Info |
|---|
| Note that you can only specify one source and one target server per configuration.castmigration file. |
<MBSchema> tag
This tag defines the CAST AIP schemas that will be migrated from the source RDBMS to the target CSS2 serverCSS server:
| Element | Description | Options | Required |
|---|---|---|---|
| name | Defines the name of the Management Service you would like to migrate. | Name of the CAST Management Service. | Yes |
| skipCustomTables | When set to True, any custom tables you may have created in the CAST schemas on the source RDBMS will NOT be migrated to CSS. When set to False or the option is omitted entirely, then all tables are migrated. | True | False | No |
| state | This option should be left blank. It will be updated with a status on completion of the migration process:
| N/A | Yes |
| isSelected | This option can be set to True (the Management Service and all associated schemas will be migrated) or False (the Management Service and all associated schemas will NOT be migrated). | True | False | Yes |
| Info |
|---|
Note that:
|
<KBSchema> / <CBSchema> tag
These two tags must be defined as child tags of the <MBSchema> tag:
| Element | Description | Options | Required |
|---|---|---|---|
| name | Defines the names of the Analysis or Dashboard Services you would like to migrate. These services must be associated to the parent Management Service you have defined in the <MBSchema> tag. | Name of the CAST Analysis or Dashboard Service. | Yes |
| skipCustomTables | When set to True, any custom tables you may have created in the CAST schemas on the source RDBMS will NOT be migrated to CSS. When set to False or the option is omitted entirely, then all tables are migrated. | True | False | No |
| state | This option should be left blank. It will be updated with a status on completion of the migration process:
| N/A | Yes |
Examples
Oracle using SID
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="oracle.jdbc.OracleDriver" originServerUrl="jdbc:oracle:thin:@192.168.20.10:1521:ORA" targetServerDriverClassName="org.postgresql.Driver"
targetServerUrl="jdbc:postgresql://192.168.20.11:2280/postgres" licenseKey="Sample&Test:1;AIP/EFP:20121031:ABCDEFGH" forceCSS2Storage="true">
<MBSchema name="ABC_MNGT" state="" skipCustomTables="true" isSelected="true">
<KBSchema name="ABC_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="ABC_CENTRAL" skipCustomTables="true" state=""/>
</MBSchema>
</Configuration> |
Oracle using Service
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="oracle.jdbc.OracleDriver" originServerUrl="jdbc:oracle:thin:@//192.168.20.10:1521/PRODMASSTEST05.castsoftware.com" targetServerDriverClassName="org.postgresql.Driver" targetServerUrl="jdbc:postgresql://192.168.20.11:2280/postgres" licenseKey="Sample&Test:1;AIP/EFP:20121031:ABCDEFGH" forceCSS2Storage="true">
<MBSchema name="ABC_MNGT" state="" skipCustomTables="true" isSelected="true">
<KBSchema name="ABC_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="ABC_CENTRAL" skipCustomTables="true" state=""/>
</MBSchema>
</Configuration> |
...
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="net.sourceforge.jtds.jdbc.Driver" originServerUrl="dbc:jtds:sqlserver://192.168.20.15:1433" targetServerDriverClassName="org.postgresql.Driver"
targetServerUrl="jdbc:postgresql://192.168.20.11:2280/postgres" licenseKey="Sample&Test:1;AIP/EFP:20121031:ABCDEFGH" forceCSS2Storage="true">
<MBSchema name="XYZ_MNGT" skipCustomTables="true" state="" isSelected="true">
<KBSchema name="XYZ_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="SYZ_CENTRAL" skipCustomTables="true" state=""/>
</MBSchema>
</Configuration> |
Migrating only one schema
In this example, only the V123_LOCAL schema will be migrated. Adding state="Migrated" to the V123_MNGT and V123_CENTRAL schemas will force only the V123_LOCAL schema to be migrated:
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="oracle.jdbc.OracleDriver" originServerUrl="jdbc:oracle:thin:@//192.168.20.10:1521/PRODMASSTEST05.castsoftware.com" targetServerDriverClassName="org.postgresql.Driver" targetServerUrl="jdbc:postgresql://192.168.20.11:2280/postgres" licenseKey="Sample&Test:1;AIP/EFP:20121031:ABCDEFGH" forceCSS2Storage="true">
<MBSchema name="V123_MNGT" skipCustomTables="true" state="Migrated" isSelected="true">
<KBSchema name="V123_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="V123_CENTRAL" skipCustomTables="true" state="Migrated"/>
</MBSchema>
</Configuration> |
Note that if you are only migrating either the Analysis or Dashboard Service (KBSchema or CBSchema), you should ensure that you attach this schema to a Management Service (MBSchema/MNGT) in the target CSS2 server CSS server using the CAST Management Studio:
...
| Code Block |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<Configuration originServerDriverClassName="oracle.jdbc.OracleDriver" originServerUrl="jdbc:oracle:thin:@//192.168.20.10:1521/PRODMASSTEST05.castsoftware.com" targetServerDriverClassName="org.postgresql.Driver" targetServerUrl="jdbc:postgresql://192.168.20.11:2280/postgres" licenseKey="Sample&Test:1;AIP/EFP:20121031:ABCDEFGH" forceCSS2Storage="true">
<MBSchema name="V123_MNGT" skipCustomTables="true" state="" isSelected="true">
<KBSchema name="V123_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="V123_CENTRAL" skipCustomTables="true" state=""/>
</MBSchema>
<MBSchema name="XYZ_MNGT" skipCustomTables="true" state="" isSelected="true">
<KBSchema name="XYZ_LOCAL" skipCustomTables="true" state=""/>
<CBSchema name="SYZ_CENTRAL" skipCustomTables="true" state=""/>
</MBSchema>
</Configuration> |
...