Migrating data from one BMC Helix CMDB server to another

To create a migration job

Perform the following steps to create a migration job:

1. On the computer where the BMC Atrium Integrator Spoon client installed, select Start > Programs > BMC Software > AR System > BMC Atrium Integrator Spoon.
2. The AR System server connection dialog box appears.
3. Log on as follows:
   1. From the AR Server list, select the AR System server on which you have installed the AR System database.
   2. In the User Name field, enter the user name for the AR System server.
   3. In the Password field, enter the credentials for the AR System server.
   4. Click OK.
4. In the Atrium Integrator Spoon window, select File > New > Transformation.
5. In the navigation panel, click Input.
6. Click CMDBInput step and drag it to the canvas.
7.  Double-click the CMDBInput step.
8. In the Connection field of the CMDBInput dialog box, perform one of the following actions.
   • Select a connection to the BMC Helix CMDB on your development server.
   • Create a new connection to the BMC Helix CMDB on your development server by performing the following steps:
     1. Click New.
     2. In the Server Name field of the Database Connection dialog box, type the name of your AR System server.
     3. (optional ) Type the port number.
     4. Type the user ID and password to log on to BMC Helix CMDB.
     5. Click Test to validate the connection.
     6. Click OK.
9. In the Class Name field, click Browse to select the BMC Helix CMDB class from which you want to migrate data.
   The NameSpace field displays the namespace for the selected class.
10. In the Dataset Id field, select the dataset from which you want to migrate data.
11. Click OK.
12. From the Output menu in the navigation panel, click the CMDBOutput step and drag it to the canvas.
13. Repeat step 6 to step 9 to create a connection to the BMC Helix CMDB on your server through the CMDBOutput step.
14. In the key look up area, select Instance Id in the Table field column and type InstanceId in the Stream field 1 column.
    This mapping enables you to keep the same Instance Ids as you transfer data from the BMC Helix CMDB on your development server to the BMC Helix CMDB on your production server.
15. Create a hop from the CMDBInput step to the CMDBOutput step. For information about creating a hop, see Connecting-transformation-steps-or-job-entries-in-Atrium-Integrator-Spoon.
16. Select File > Save as.
17. In the Transformation Properties dialog box, specify a name for the transformation.
18. Click OK.
    You can run this transformation in Atrium Integrator Spoon. However, you must envelop this transformation in a job to be able to monitor and run it from the Atrium Integrator console.
19. Select File > New > Job.
20. From the General menu in the navigation panel, select the Start step and drag it to the canvas.
21. Click and drag the Transformation step to the canvas.
22. Double-click the Transformation step.
23. In the Name of transformation field, click  to select the transformation you had created in step 16.
24. Click OK.
25. Select File > Save as.
26. In the Job Properties dialog box, specify a name for the job.
27. Click OK.

The job is now displayed in the Atrium Integrator console.