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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Tools to Compare Datav...
Power Apps
Answered

Tools to Compare Dataverse Tables

(0) ShareShare
ReportReport
Posted on by 20

Power Platform Community... I am looking for ANY tools to compare Dataverse tables... in the same instance or from different instances.

 

My searches are coming up slim to none.

I have the same question (0)
  • gulshankhurana Profile Picture
    1,397 Moderator on at

    Hi @rodrickhalesdhs 

     

    You could try XRMtoolbox for such tasks:

     

    https://www.xrmtoolbox.com/plugins/Greg.Xrm.EnvironmentComparer/

     

    https://www.xrmtoolbox.com/plugins/RioCanada.Crm.ComponentComparerExporter/

     

    https://www.xrmtoolbox.com/plugins/CRMP.XTBPlugin.SystemComparer/

     

    I haven't personally tried any of these tools yet (not needed in any of my projects) but I hope you find in XRMtoolbox what you are looking for.

     

    Kind regards 

    Gulshan

    Please give it a thumbs up 👍🏻 if you appreciate my efforts.

    If my answer helped you resolve your issue then please also mark it as a solution   so that it helps others experiencing the same problem.

     

     

  • fedops Profile Picture
    20 on at

    ...Thanks for your response. What I really mean is the table rows (records). I understand about these other tools.

  • Verified answer
    gulshankhurana Profile Picture
    1,397 Moderator on at

    https://www.xrmtoolbox.com/plugins/MscrmTools.ComponentComparer/

     

    The description for this tools says that you can compare records between two environments. Not sure how much it'd be of help.

     

    Have a look at this link too:

    https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-to-compare-data-in-Dataverse-between-sandbox-and-production/td-p/1690691

  • ivan_apps Profile Picture
    2,189 Moderator on at

    What kind of comparison are you thinking of? You can’t have two identical tables in one instance so are you comparing specific columns between two tables? What is the outcome that you would expect from this comparison, de-dupe or unique only?

     

    you may want to look at capabilities of Power BI, it can do matches, data analysis and normalize tables for comparison if that fits the need. 

  • fedops Profile Picture
    20 on at

    Thanks for your response. I want to compare records (rows) from two tables in the same environment or another environments.

  • ivan_apps Profile Picture
    2,189 Moderator on at

    Yes but how do want the comparison to happen. Are you looking at two columns within the rows and saying “if the these two match, they are equivalent” or are you comparing each column in each row?

    are the table schemas the same such that there exists an exact match in the two compared tables? Ex: new_comparecol exists in env1 as well as env2.

    i still think your best best is probably a power bi report to display matches based on an inner join.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard