Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Are there data migrati...
Customer experience | Sales, Customer Insights,...
Suggested answer

Are there data migration tools, which can move data across different tables and environments?

(0) ShareShare
ReportReport
Posted on by KVa 293

Is there some data migration tool, which can migrate data between environments and different tables. I found the Data Migration Utility or the Data Migration Tool in the XrmToolBox, but they always map the "same" tables to each other (account with account, or contact with contact).

We have a custom table in one environment, which we'd like to move to another environment, and copy to the Lead table. So we need to have the ability to copy data from a custom table to another table in another environment (e.g. environment1.dev_customleads -> environment2.leads)

  • Suggested answer
    NH-25062040-0 Profile Picture
    NH-25062040-0 6 on at
    Are there data migration tools, which can move data across different tables and environments?
    Yes! Try MigrateMyCRM. You can accept the default object mappings, or you can edit and change the target/destination object for each source object.
  • Community member Profile Picture
    Community member 2 on at
    Are there data migration tools, which can move data across different tables and environments?
    When it comes to migrating your data from SQL Server to Snowflake in real-time, having the right tool is essential. A real-time data replication tool sql server to snowflake ensures that your data is continuously synchronized between the two systems, minimizing downtime and ensuring the seamless transition of your data to Snowflake.
  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Are there data migration tools, which can move data across different tables and environments?

    Hey!

    Besides using Kingswaysoft, you can build your own tool by making HTTP requests to Dynamics (or using PowerAutomate/logic apps), get the set of data you need, and then connect to another environment/table.

    Also, if you go to your target environment and generate an import template with 8-10 fields that you need, you can then export the data from your custom table (using excel) to reflect the same template.  I think this would be the easier approach.

    Regards

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at
    RE: Are there data migration tools, which can move data across different tables and environments?

    Hello,

    I would recommend taking a look at SSIS with KingsWay soft adapters. Sounds like a tool for your task.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,217 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,978 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans