September 23, 2010 at 8:06 am
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
May 25, 2016 at 6:53 am
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/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply