|
I need to compare tables data between SQL servers and if data is different move the data. Does some one has an example how to do this?
|
|
|
This could be hugely complicated. Can you narrow the question down to specifics? I assume since you're posting in the ASP.NET forum, that you want to do this online, using ADO.NET.
Can you already connect to each server? Can you perform the propery queries? Are the table structures exactly the same?
|
|
|
|
|
I need to compare to data sets wchich are represents 2 tables (same name) from different server.
|
|
|
Still not specific enough.
Do you know how to build the datasets already?
Do you have a working ASP.NET program, or not?
How far along is the program?
Can you connect to the two servers, yes or no?
Can you query the two databases, yes or no?
Can you load the results of the query into a dataset, yes or no?
What is the structure of your dataset? Why are you using a dataset for a single table? I suggest using a SqlDataReader, to process the results into an ArrayList. Then compare the two ArrayLists with a for loop.
|
|
|
|
|
|
|
|
|
|