Free tools/libraries to compare tables with filtering for SQL Server 2008 and visualize/sync diffs t

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/17 2:53 UTC
Read the original article Hit count: 365

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 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#.

© Stack Overflow or respective owner

Related posts about sql

Related posts about diff