Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, July 11, 2016 10:58 AM
Points: 65, Visits: 318
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
Posted Wednesday, May 25, 2016 6:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 8, 2016 7:08 AM
Points: 11, Visits: 12
I realise this is an old post, but if anyone is having a similar problem then I have developed a software tool that will perform most of these data comparisons.
SQLC is currently in beta version for free download and evaluation. It will allow you to compare two tables in different databases where the structure is not identical. You have the option to omit columns from the comparison on either side if, for example an extra column exists on one side you can ignore it.
It also lets you compare two views or a table against a view. So if one table has datatypes different to the other then you just need to create a view over one table which converts the datatypes to be the same as the other table.
SQLC is available for free download here http://sqlc.azurewebsites.net/
Post #1789595
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse