Comparing tables with filtering in different databases and visualizing diffs/pushing changes
- by MicMit
I am building certain GUI in C# for a content manager and looking for the tools or code snippets or open libraries ( code ideally in C# ) which allow me the following :
1. For table A in database X (test ) and table A in database Y (production) and for a simple filter ( e.g. listname = "XYZ" ) I need to show additions/deletions/updates in some way.
which might be
side-by-side
or just
2 record added
table with some fields
2 record deleted
table with some fields
Considering that this task is very common, I guess, certain components should exist ?
Components either return some collections from parameters given for further visualizing or just produce for e.g. html report.
2. I need to push changes for the filter I mentioned in 1 and update table in production database for this filter only ( ie for the particular list approved by content person). Again probably there are certain SQL code generators - components in addition to diffs or standalone.
