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
Ray Megal
shared this idea
-
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.