Comparison gaffe with data compression
edited March 19, 2012 3:52PM in SQL Compare Previous Versions
I am comparing two 2008 databases with a page compressed index. If there are any major differences between the two tables (e.g. a foreign key is missing from one side), the comparison shows that I also need to add COMPRESSION = PAGE to one of the tables. The resulting script shows nothing about this however, and if I create the foreign key manually (not changing anything with compression), the tables are now considered identical. See screen shot below for the comparison delta indicator and the resulting script (which also changes nothing about compression).
0 · Share on Twitter