web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Migrating Data from Dy...
Microsoft Dynamics CRM (Archived)

Migrating Data from Dynamics 365 Sandbox to Dynamics 365 Production

(0) ShareShare
ReportReport
Posted on by Huzefa Bootwala 320

Hello,

I will be soon migrating data from Dynamics CRM 365 Sandbox to 365 Production.

I should do the following: Put all the customizations in a solution and import in 365 Production.

Import the data using Kingswaysoft SSIS from Sandbox to Production.

Is there any other way of doing the migration?

Thank you.

*This post is locked for comments

I have the same question (0)
  • Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    There are other tools that are available, but that should be the general approach. KingswaySoft CRM connector is a great tool for data migration.

    Read the data from Sandbox and update Production.

    I would recommend having a staging environment to pull the data into in case you need to do some data manipulation or lookup data (such as users or other lookup entities).

    Hope this helps.

  • Huzefa Bootwala Profile Picture
    Huzefa Bootwala 320 on at

    Hello,

    Thank you fo your reply.

    My project was to migrate the data from CRM 2013 OnPremise to Dynamics 365 online. I have migrated all the data to Dynamics 365 Sandbox (I believe this is the staging environment). Now I need to move data from sandbox to production environment.

    I already have the users in Dynamics 365 Production.

  • Ruben Aghajanyan Profile Picture
    Ruben Aghajanyan on at

    There is a XRMToolBox control called "Data Migration using FetchXml". You can specify columns and filter criteria in the fetchXml and data according to that query will be transferred from source to target.

    8787.datamigrationbyfetchXml.gif

    Here are the steps.

    1. In the source instance go to advanced find (Microsoft removed it from UCI, but still available in "Advanced Settings"), specify columns, and filter criteria of the entity which data should be migrated.

    2. Download the fetchXml file from the advanced find.

    3. Add fetchXml file in the XrmToolBox control.

    4. Click "Transfer Data".

    marketplace.bevercrm.com/.../DataMigrationUsingFetchXml

    www.xrmtoolbox.com/.../DataMigrationUsingFetchXml

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans