I'm trying to set up a background worker than can compare individual tables/databases between SQL instances. Each table compared (chosen either individually or during a scan of the database) returns 2 tables. One table for machine 1 and one table for machine 2 showing the differences in each as compared to the other.
I was to be able to use the same code for both. Basically a single dataset consisting of 2 results tables for each chosen table in a database. To that end I've been trying to implement a system of Dataset arrays. Where by I only initialize 1 element for and individually chosen table, and dynamically initialize a variable amount of elements based off the the number of tables of the chosen Database. Then populate each element with their respective 2 comparison results tables. For individually chosen tables: dataSet[0].Tables[0] dataSet[0].Tables[1] For a database comparison: dataSet[0].Tables[0] dataSet[0].Tables[1] dataSet[1].Tables[0] dataSet[1].Tables[1] etc..... It seems to be working through the DoWork event yet when I attempt to check the tables, they're all blank. As in 0 columns. It seems like the entry for however many tables came through but the actual data for those tables is lost. I was wondering if anyone else had attempted anything similar or had any other idea's as to how I could go about this.
