Diff table mechanism in VBA

[jaryszek]

Hi Guys,

The goal is to compare all tables from old workbook and check all changes in master workbook and have output like here:

Screenshot_25.png

i have Schema worksheet from i know what primary keys exist in tables, to simplyfi example i added 2 the same tables in on worksheet:
Screenshot_26.png

As you can see Table2 is in Master Workbook and:
1. For Primary Key column name : Deployment = "Windows" there was change for column Group from Group1 to Group666 ("Updated")
2. For Primary Key : Deploment = "Linux" entire row was deleted ("Deleted")

I outputted results in Output worksheet.

And now. How to create mechanism for it?
Use AdODB sql in VBA and somehow compare tables using joins or loop one by one and compare one record by another record using dictionary objects?
Or...what else? I do not know how to start and no idea for this.

Please help,
I will be grateful for any tips and support,
Jacek

[jaryszek]

I am really appreciate any help.

What if i will create parent dictionaries:

TabName + PrimaryKey row and for PrimaryKey row add children dicrionaries for each column?

Hmm i am afraid about performance.

Jacek