Support Portal

Welcome, Guest Login

Support Center

DxTransfer Not Able to Copy Microsoft SQL Agent Jobs, Backup Devices, Alerts, or Operators

Last Updated: Jul 17, 2017 03:52PM PDT

Applies to...

  • DxTransfer
  • 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.

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found