Comparison gaffe with data compression

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Comparison gaffe with data compression

Postby AaronBertrand » Mon Jul 12, 2010 3:16 pm

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).

[url]http://sqlblog.com/files/folders/26937/download.aspx[/url]
AaronBertrand
 
Posts: 44
Joined: Wed Oct 22, 2008 1:26 pm

Postby Chris Auckland » Mon Mar 19, 2012 8:52 pm

This has now been fixed in SQL Compare 10.1 and can be downloaded through Help | 'Check for Updates'
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 2 guests