Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 287

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,323 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans