Red Gate forums :: View topic - Comparison gaffe with data compression
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Comparison gaffe with data compression

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
AaronBertrand



Joined: 22 Oct 2008
Posts: 44

PostPosted: Mon Jul 12, 2010 3:16 pm    Post subject: Comparison gaffe with data compression Reply with quote

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

http://sqlblog.com/files/folders/26937/download.aspx
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Mar 19, 2012 8:52 pm    Post subject: Reply with quote

This has now been fixed in SQL Compare 10.1 and can be downloaded through Help | 'Check for Updates'
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group