How to compare two dataset?
in [Server Configuration]
|
From: aspfun via SQLMonster.com on 21 Apr 2010 09:34 In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They are coming from two tables which are in two different SQL server: [Order1] (in server1) and [Order2] (in server2). These two tables have the same data structure. How to code to compare two dataset and then insert difference into another table without using linked server? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201004/1
From: Uri Dimant on 21 Apr 2010 09:44 VB.NET/C# do not have such possibility? Loop thru the sets and compare them on the client "aspfun via SQLMonster.com" <u53138(a)uwe> wrote in message news:a6dd1a28567a0(a)uwe... > In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They > are > coming from two tables which are in two different SQL server: > [Order1] (in server1) and [Order2] (in server2). > These two tables have the same data structure. > How to code to compare two dataset and then insert difference into another > table without using linked server? > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201004/1 >
From: TheSQLGuru on 21 Apr 2010 11:05 ApexSQL Data Diff Disclaimer: I have a close relationship with Apex, use their products and recommend them to my clients. Also, if you care to you can mention TheSQLGuru sent you you will get a discount and my daughter will get a few coins for her college fund. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "aspfun via SQLMonster.com" <u53138(a)uwe> wrote in message news:a6dd1a28567a0(a)uwe... > In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They > are > coming from two tables which are in two different SQL server: > [Order1] (in server1) and [Order2] (in server2). > These two tables have the same data structure. > How to code to compare two dataset and then insert difference into another > table without using linked server? > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201004/1 >
From: Erland Sommarskog on 21 Apr 2010 17:57 aspfun via SQLMonster.com (u53138(a)uwe) writes: > In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They > are coming from two tables which are in two different SQL server: > [Order1] (in server1) and [Order2] (in server2). > These two tables have the same data structure. > How to code to compare two dataset and then insert difference into another > table without using linked server? That sounds like a basic ADO .Net exercise, for which you probably will get better help in C#/VB forum. That is, you would do the comparison in the client and then update the tables when you are done. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: aspfun via SQLMonster.com on 23 Apr 2010 14:09 Erland Sommarskog wrote: >> In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They >> are coming from two tables which are in two different SQL server: >> [Order1] (in server1) and [Order2] (in server2). >> These two tables have the same data structure. >> How to code to compare two dataset and then insert difference into another >> table without using linked server? > >That sounds like a basic ADO .Net exercise, for which you probably will >get better help in C#/VB forum. That is, you would do the comparison in >the client and then update the tables when you are done. > I used sqlBulkCopy to make it done. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201004/1
|
Pages: 1 Prev: Command Within SQL to get Windows login Name Next: Retaining CDC History |