Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Where to get and how to use the Data Migration Utility/Tool

Posted on by 285

I'm trying to migrate data and configurations from a CRM 2015 production environment into a sandbox environment of the same version. The environments are set up on different machines. 

I've found many mentions of the Data Migration Utility/Tool that's supposed to make this an easy process, but I can't seem to find where to get this tool. 

I've found instructions on how to use it for my purposes here, and this is the only place that seems to mention where to get it from, but it leads me to a post about the Microsoft nuget repository, and none of the packages make any mention of the Data Migration Tool. Another problem with the nuget approach is that my sandbox environment doesn't have internet access, so I would need to install the package manually through CLI, from what I understood. I attempted that with the "Microsoft.CrmSdk.CoreTools" package as it sounded close to what I'm looking for in name and content, but the install commands weren't working and a post mentioned a trick of changing the package extension to see the contents, and the package didn't have the Data Migration Tool at all, neither does it follow the directory structure mentioned in the guides.

I'm pretty confused about how to migrate the data using an elusive tool. Any help or relatively user-friendly alternatives would be appreciated.

*This post is locked for comments

  • jdalske Profile Picture
    jdalske 536 on at
    Where to get and how to use the Data Migration Utility/Tool
    I am having the same issue.  It looks like the process to set the tool up is not documented.  I try using Pakcage Manager Console and it looks like it installs but I can't find it.  I tried via Powershell and get the same results.  It does nothing.  I am trying to migrate data from one 9.1 org on-premises into another 9.1 org on-premises.    They are fairly similar but exports and imports throw far too many errors.  I did request the download for KingswaySoft.  I still would like to see the data migration utility work though.  Any feedback would be greatly appreciated. 
  • Artemy Profile Picture
    Artemy 285 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    [quote user="Alex Shlega"]

    Actually, Kingsway is free if you are using it within your dev tools (might also look at Cozyroc: http://www.cozyroc.com/ ):

    "The free developer license is fully-functional within your development tools (SSDT-BI, BIDS, or Visual Studio). The only limitation is the inability to run the software outside your development tools."

    Unless you want to schedule everything, you should be fine.

    It's much more flexible and convenient than the data migration tool (considering that you can run the whole data migration package at the click of a button, that's not to mention you can use just any fetchXml with SSIS.. and you can do no filtering at all with the data migration tool)

    [/quote]
    Would this approach work if the sandbox environment that I'm trying to migrate the data to is not connected in any way to the live environment? I was envisioning a process where the data is zipped up through an export functionality, then I can upload this package to the sandbox and run an import from the package into the sandbox database.
  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    I believe the latest version should work with 2015, at least according to this link:

    http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/help-manual

  • Artemy Profile Picture
    Artemy 285 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    [quote user="Alex Shlega"]

    Actually, Kingsway is free if you are using it within your dev tools (might also look at Cozyroc: http://www.cozyroc.com/ ):

    [/quote]

    [quote user="Scott Durow"]

    I would always use Kingswaysoft for data migration - the configuraiton migration tool is for moving small numbers of records specifically where you have configuration/reference data to move between DEV/TEST/PROD.

    [/quote]
    Do I just go here and press the corresponding download button or would I need to go to the release archive and get an older version to be compatible with on premise CRM 2015? 
  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    If you still want to use the data migration tool, you'll need to download 2015 sdk(the utility is part of that sdk package):

    www.microsoft.com/.../details.aspx

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    Actually, Kingsway is free if you are using it within your dev tools (might also look at Cozyroc: http://www.cozyroc.com/ ):

    "The free developer license is fully-functional within your development tools (SSDT-BI, BIDS, or Visual Studio). The only limitation is the inability to run the software outside your development tools."

    Unless you want to schedule everything, you should be fine.

    It's much more flexible and convenient than the data migration tool (considering that you can run the whole data migration package at the click of a button, that's not to mention you can use just any fetchXml with SSIS.. and you can do no filtering at all with the data migration tool)

  • Artemy Profile Picture
    Artemy 285 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    [quote user="Scott Durow"]

    Yes - it works!

    [/quote]
    It looks like my on-premise CRM 2015 is incompatible with the latest SDK that the data migration utility uses.
    "Metadata contains a reference that cannot be resolved: 'http://crm.company.com:444/XRMServices/2011/Discovery.svc?wsdl&sdkversion=9'"
    Are there any older versions of this tool for sdkversion=7?
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    I would always use Kingswaysoft for data migration - the configuraiton migration tool is for moving small numbers of records specifically where you have configuration/reference data to move between DEV/TEST/PROD.

  • Artemy Profile Picture
    Artemy 285 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    [quote user="sdnd2000"]

    It should be in sdk tools, but for data migration, I suggest to use scribe or kingswaysoft

    [/quote]
    Why would you suggest a paid tool over the free tool? What are the advantages and why are they necessary?
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Where to get and how to use the Data Migration Utility/Tool

    Yes - it works!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans