What are the challenges you face when working across database platforms? Take the survey

SQL Compare failing to detect data compression

mwjdavidsonmwjdavidson Posts: 5
edited December 30, 2010 12:57PM in SQL Compare Previous Versions
I'm using SQL Compare to compare a physical SQL Server 2008 database in which page-level data compression has been applied to all tables to a set of scripts. Where a difference other than the compression exists for a given table, the table correcly appears under the "objects that exist in both but are different" section. However, where the only difference is the compression setting, the table only appears within the "identical objects" section. Curiously, selecting such a table in this section to display the scripts shows the difference with highllighting!
Has anyone else experienced this?




Sign In or Register to comment.