nwang66
15 years agoContributor
Compare two DBTables objects
Hi,
I need to compare data from two different database servers. Both are SQL Server, but different connection strings. So I create two Stores | DBTables, say DBTables1 and DBTables2, then compare if records in DBTables1 are same as DBTables2. It works in most cases, sometimes it doesn't. If my SQL query doesn’t return any record, which is one of normal cases, then the DBTables cannot be created. Is this configured in the Project Properties? Or should I use other way to do this test?
Thanks a lot!
Nancy