Option to Ignore Temporal/History Table
It would be handy to have an option to ignore Temporal/History table configuration when comparing two like databases where one has had some tables configured as temporal with a history table. This would be helpful to isolate any other changes outside of the temporal/history configuration.
20
votes
![](https://secure.gravatar.com/avatar/72abaa64bf167d5299bd7fd3e99e2356?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Mark Bajema commented
When comparing two databases with temporal tables and you've set SYSTEM_VERSIONING to OFF in one of them, SQL Compare shows all the base tables as different and the history tables as objects found only in one of the databases.