- Microsoft SQL Server
DxTransfer is not able to copy Microsoft SQL Agent Jobs, Backup Devices, Alerts, or Operators to the target instance when selected in the Options section.
The DxTransfer utility relies on OLE stored procedures that reference SQL-DMO libraries on the source instance to gather data needed to copy agent jobs, backup devices, alerts, and operators. This does not affect the SQL Server target instance.
The SQL-DMO functionality is not installed by default on Microsoft SQL Server 2008 or later.
To resolve this, you will need to install the "Microsoft SQL Server 2005 Backward Compatibility Components" package.
Once installed on the source server, jobs, backup devices, alerts and operators can be migrated to the target instance via DxTransfer.