Support Portal

Welcome, Guest Login

Support Center

Things to be Aware of When Using DxTransfer

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

Applies to...

  • DxTransfer
  • Microsoft SQL Server

Summary

These are the things you need to be aware of when using DxTransfer to migrate instances of Microsoft SQL Server.

Information

  • If SQL Mail was setup on your source instance, then you will need to setup and grant the needed users mail role in msdb on the target instance.
  • Verify the accounts used on linked servers. Modify linked servers using the correct username and password for the connections on the target instance.
  • Check to see which users have what server level roles (sysadmin, securityadmin, etc). DxTransfer does not copy server roles.
  • Enable adhoc query and xp_cmdshell setting as needed.
  • Verify jobs were migrated successfully. If not, then script out the missing jobs from the source instance and run them on the target instance.
  • Verify max memory settings on the target instance as needed.
  • Setup backup and database maintenance plans as needed on the target instance.
  • Verify if there are any special users that have permission in the master or msdb database on the source instance. If so, they will need to be added to the target instance.
  • If there are special objects created in master and msdb database (like stored procedures) on the source instance, then they will need to be recreated on the target instance.

Contact Us

support.desk@dh2i.com
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete