How to ignore different datatyes

peter eh

We have a system with a live and an archive DB and I now need to track all changes made in the live DB in the archive DB. The problem is that a field named tst has the datatype timestamp in the live DB and the datatype binary(8) in the archive DB. This field exists in every table and SQL Compare now shows me all 600 tables as different, which means a lot of work for me, because I have to check all 600 tables manually if the different datatype is the only difference or if there are other differences.
I have already tried the following without success:
- Unmap the tst field in table mapping and uncheck the "Auto-map similar columns" in Options.
- Check the filter if it is possible to exclude table fields

Is there a way to solve this particular problem with SQL Compare?

DanC

Hi @peter eh

This would come under as a feature request, I would advise posting the idea here: https://redgate.uservoice.com/forums/141379-sql-compare