Migrate Database Components
Important: | After you migrate database components to 9.9, you can no longer use them with your old environment. |
On the machine on which you installed Database Configuration 9.9, open a command window or shell, go to the 9.9_Software AG_directory\common\db\bin directory, and migrate database components by running the commands below. After you run each command, check the log file dcc_yyyymmddhhmmss in the 9.9_Software AG_directory\common\db\logs directory.
If you are using an Oracle or DB2 RDBMS, and you are not using the default tablespace, also specify the -tsdata data_tspace_name and -tsindex index_tspace_name parameters.
On an AIX system, enclose the values “db_server_URL”, ”existing_db_user”, and “password” in quotation marks.
If you are migrating the Integration Server database components, you must migrate them first.
1. Run this command for each Integration Server database component you need to migrate:
dbConfigurator.{bat|sh} -a migrate -d {oracle|sqlserver|db2luw}
-c database_component_name -v latest -l db_server_URL
-u existing_db_user -p password
2. Migrate the rest of the database components.
If you want to migrate the rest of your database components at the same time, run this command:
dbConfigurator.{bat|sh} -a migrate -d {oracle|sqlserver|db2luw}
-c all -v latest -l db_server_URL -u existing_db_user -p password
Note: | Since you already migrated the Integration Server database components, and you most likely do not have all other database components (because you most likely do not have all products), you will see messages in the log file that say migration failed for the database components you do not have. You can ignore these messages. |
If you want to migrate the rest of your database components individually, run this command for each database component you need to migrate:
dbConfigurator.{bat|sh} -a migrate -d {oracle|sqlserver|db2luw}
-c database_component_name -v latest -l db_server_URL
-u existing_db_user -p password
