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.
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.
Thanks for your response. I want to compare records (rows) from two tables in the same environment or another environments.
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.
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:
...Thanks for your response. What I really mean is the table rows (records). I understand about these other tools.
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.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2