Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Comparison Expand / Collapse
Author
Message
Posted Thursday, September 23, 2010 8:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 6:35 AM
Points: 65, Visits: 312
Hi,

I am about to write a custom SQL solution for data comparison between two data sources - old one is the existing production and new one with new changes. I am tasked to do the data comparison between the two. Here is some of the facts why I think I need to write custom solution:

1. Table name is different for some of the tables but column names are same
2. Table name is same but columns names are diff
3. Table name and column name is same but data type is different
4. table name, column name, and data type is different is different

We have SQL Data Compare tool which is awesome but if data type is different it cannot compare the data. So this is not an option.

What are my other options here? How about your experience?

Thanks
Post #992046
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse