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

Migrate Data from the Cohesion Database to an Archive File

After ensuring the migration prerequisites have been satisfied, you can migrate data from the Cohesion Database into a JAR file.

To migrate data from the Cohesion CA Configuration Automation 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 Archive File link in the From Cohesion Database panel.

   The Cohesion Database Details page appears.

3. Enter the following information in the corresponding field in the Cohesion Database Details panel, 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. Enter the following information in the corresponding field in the Archive Details panel:

   File Path

   Specifies the location where you want to save the JAR file.

   File Name

   Specifies the name of the JAR file (.jar is automatically appended to this entry).

5. Click Next.

   The Shared Objects page appears.

6. Click one of the following object types to migrate:
   • Servers
   • Services
   • Blueprints
7. (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.

8. (Optional) Create a filter if you only want to migrate certain objects to the archive file.
   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.
9. (Optional) Repeat steps 5 through 8 to include other object types.
10. Click Finish.

    The migration begins and confirms that the archive file was successfully created.