March 8, 2007 at 9:56 am
Hi ,
In advance Thanks for any help!
I have a situtaion to compare data between two tables residing in two different databases. There are two databases (db1 & db2).
db1 is completely relational with defined business rules. Typical production database.
db2 is not relational,(I mean no relationship between the tables. All tables are just created individually thru DTS while loading the data from flat files).
In both the databases data is coming from same source(Flat files)
In db1 - we are loading the data thru SSIS. (Data is loaded into multiple tables (db1 is completely relational)
In db2 - we are loading the data manually thru DTS and we are creating each flat file as one table.
Task is, we need to compare the data in record level between the tables residing in db1 & db2 databases by T-SQL scripts.
If anyone has T-SQL script for this scenario, if you can share it or suggest any other advises or methods to accomplish this task will be greatly appreciated.
Thank you again!
March 8, 2007 at 10:15 pm
lots of different scripts to do this in the scripts contribution area; search for "compare" and youll get results like these:
| Scripts | Rating | Search Score |
| Smart Index Manipulation system | 4.23 | 100 |
| Compare the Data in Two Tables | 0 | 99.12 |
| Compare Definition and Data of table in 2DBs | 3.67 | 98.25 |
| Check in New DDL to SourceSafe | 4.38 | 98.25 |
| Case Sensitive String Compare User Function | 3 | 98.25 |
| Case-Sensitive String Comarison on Any SQL Server | 3 | 97.81 |
| Monitor Database and Log Growth | 4.8 | 97.81 |
| Finding All Index Info for Small Databases | 4 | 97.81 |
| Compare the data of 2 Tables (Updated) | 4.67 | 97.37 |
| sp_CompareTblCnts | 3.8 | 97.37 |
| sp_DBCompare | 4.54 | 97.37 |
| Dynamic String Compare (W/O the dynamic sql) | 3 | 97.37 |
| Script to compare 2 tables | 2 | 97.37 |
| Encryption Example | 3 | 96.93 |
| Get Notified When Accounts Are Changed | 4.38 | 96.93 |
| Compare the Data of 2 Tables (Improved) | 4.21 | 96.93 |
| Compare Parallel Data Streams | 3.67 | 96.93 |
| compare table counts in two databases | 3.75 | 96.93 |
| Script To Compute Checksum Of The Text Field | 4.8 | 96.93 |
| Generate Quick Snapshot of table structures. | 4.5 | 96.93 |
| More Results | ||
Lowell
March 9, 2007 at 9:17 am
This is a cross-post. Continue here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=350095
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply