• 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]