Answered

Tools to Compare Dataverse Tables

(0) Share

Report

Posted on by fedops

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

gulshankhurana 1,397 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
fedops 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

gulshankhurana 1,397 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fedops 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No