Ignore column type mismatch in data comparison

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
scotru
Posts: 2
Joined: Tue 13 Dec 2016 17:45

Ignore column type mismatch in data comparison

Post by scotru » Tue 13 Dec 2016 17:48

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?

alexa

Re: Ignore column type mismatch in data comparison

Post by alexa » Wed 14 Dec 2016 14:04

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.

Post Reply