How to migrate tasks and related configurations like email notification, schedules etc from one environment to another environment?
Article ID: KB0091523
Updated On:
| Products | Versions |
|---|---|
| TIBCO DataExchange | - |
| Not Applicable | - |
Description
Resolution:
Task migration can be done by exporting task using DX Console and importing it to the target dxsrever. But exporting and importing task only migrates task definition and it doesn't migrate the email notification, task schedules etc. To migrate the task definition as well as the related configurations, one needs to
1. export the data from the database and import it to the target database.
2. Target dxsrever needs to be configured to connect to the target database and deployed. Deployment doesn't create the tables, if the tables already exist in the database.
3. One problem with this approach is it also exports the task statistics from source databbase to target database. To avoid this, follow the step 3 mentioned in the attached document.
Attached dx_datamigration.doc, provides the detailed steps on how to export database data from one DXServer and import to another, and reset the statistics. It shows these SQLs for Oracle database.
Task migration can be done by exporting task using DX Console and importing it to the target dxsrever. But exporting and importing task only migrates task definition and it doesn't migrate the email notification, task schedules etc. To migrate the task definition as well as the related configurations, one needs to
1. export the data from the database and import it to the target database.
2. Target dxsrever needs to be configured to connect to the target database and deployed. Deployment doesn't create the tables, if the tables already exist in the database.
3. One problem with this approach is it also exports the task statistics from source databbase to target database. To avoid this, follow the step 3 mentioned in the attached document.
Attached dx_datamigration.doc, provides the detailed steps on how to export database data from one DXServer and import to another, and reset the statistics. It shows these SQLs for Oracle database.
Issue/Introduction
How to migrate tasks and related configurations like email notification, schedules etc from one environment to another environment?
Attachments
Feedback
Yes
No
Powered by
