Free tools/libraries to compare tables with filtering in different databases and visualize/sync diff
- 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 html report
2 record added
html table with some fields
2 record deleted
html 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 reports mentioned above.
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.
3. The key thing tools/libraries - should be suitable for integration with the existing application in C#.