Administering CA Configuration Automation › Migrating Data from CA Cohesion ACM › Migration Options › Migrate Data from the Cohesion Database to the CCA Database

Migrate Data from the Cohesion Database to the CCA Database

After ensuring the migration prerequisites have been satisfied, you can migrate data from Cohesion CA Configuration Automation Database into the CA Configuration Automation Database.

To migrate data from the Cohesion Database to the CA Configuration Automation Database

1. Click the Administration link, and then the Data Migration link.

   The Data Migration page appears and displays the following panels:

   • From Cohesion Database
   • From Archive File
   • Security Certificates
2. Click the To CA Configuration Automation Database link in the From Cohesion Database panel.

   The Cohesion Database Details page appears.

3. Enter the following information in the corresponding field, then click Test Connection.

   Database Type

   Specifies one of the following databases: SQL Server or Oracle.

   Server Name

   Specifies the server that hosts the Cohesion Database.

   Port Number

   Specifies the port number the Cohesion Database uses to communicate.

   Database Name

   (SQL Server database only) Specifies the SQL Server database instance.

   Oracle SID

   (Oracle database only) Specifies the system ID (SID) that uniquely identifies an Oracle database instance.

   Database User

   Specifies the user name of an administrator user who can access the Cohesion Database

   Database Password

   Specifies the password for the database user.

   CA Configuration Automation uses the supplied information to ensure it can connect to the Cohesion Database and then confirms the connection.

4. Click Next.

   The Shared Objects page appears.

5. Click one of the following object types to migrate:
   • Servers
   • Services
   • Blueprints
6. (Blueprints only) Clear one of the check boxes if you do not want to migrate that object type:
   • Migrate Blueprints
   • Global Variables

   By default, both object types are migrated.

7. (Optional) Create a filter if you only want to migrate certain objects to CA Configuration Automation r12.6.
   1. Click the Filters tab.
   2. Select an object in the Available column (you can use Ctrl+click or Shift+click to select multiple objects).
   3. Click the single right-facing arrow to move the selected objects to the Selected column.
   4. Click OK.
8. (Optional) Repeat steps 5 through 7 to include other object types.
9. Click Finish.

   The migration begins and confirms the successful migration when complete.