Ignore column type mismatch in data comparison
Ignore column type mismatch in data comparison
I have a data comparison project between two databases. The databases are essentially the same but one uses bigint and the other uses int. None of the values in the bigint table exceed the size of a maxint. I'd like to use devarts data comparison to compare tables with a mapping between the columns that are of different types. I know that in most cases mapping columns of different types would be undesirable but in my use case it is desirable. Is it possible to override the incompatible column warning?
Re: Ignore column type mismatch in data comparison
We are planning to implement such a feature in one of the next product versions.
In the meanwhile, you have to convert data to the same type (int or bigint) and then perform comparison.
In the meanwhile, you have to convert data to the same type (int or bigint) and then perform comparison.