Comparing tables with filtering in different databases and visualizing diffs/pushing changes

Posted by MicMit on Stack Overflow See other posts from Stack Overflow or by MicMit
Published on 2010-04-16T06:23:32Z Indexed on 2010/04/16 6:33 UTC
Read the original article Hit count: 303

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about sql

Related posts about diff