Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Redirect
visiblefalse
locationSTORAGE:Migrating CAST AIP schemas from Oracle Server and Microsoft SQL Server

Note

Note that this tool is no longer maintained and has been removed from CAST AIP ≥ 8.3.15 for the following reasons:

  • the tool does not support transfers to CSS3/PostgreSQL 9.6
  • CSS3/PostgreSQL must be used with CAST AIP ≥ 8.3.x (CSS2/PostgreSQL 9.2 is deprecated for use with 8.3.x)

...

OptionDescription
-configEnter the path to your configuration.castmigration file stored on the local hard drive. Use the Browse button to find the file.
-originuserEnter the username that will be used to access the source RDBMS defined in the configuration.castmigration file. CAST recommends that you use a user with DBA equivalent rights. You can also use the same level of rights that is required to install CAST schemas - this is explained here: Appendix - RDBMS requirements and configuration.
-originpasswordEnter the password for the username that you have entered in the Origin User field.
-targetuserEnter the username for your target CSS server defined in the configuration.castmigration file. This should always be Operator.
-targetpasswordEnter the password for the Operator username that you have entered in the Target User field. Unless you have changed this, it should be set to CastAIP.
-versionEnter the CAST AIP version number (for example 8.2.0) of the schemas you want to migrate. Any schemas defined in the configuration.castmigration file that do not correspond to this version number will be ignored.
-binariesEnter the path to the root folder of your CAST AIP installation, for example: C:\Program Files\CAST\8.2. The CAST AIP binaries must match the CAST AIP version of the schemas defined in the configuration.castmigration file.
-lEnter a path to a .log file in which to store the migration log.

...