Hi koro, have you tryed your method without the background worker? Sometimes the synchronization is messed up or not ready or anything...
On Thu, Aug 13, 2009 at 12:16 AM, koro <[email protected]> wrote: > > 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. >
