| Author |
Message |
AaronBertrand
Joined: 22 Oct 2008
Posts: 44
|
 Posted: Mon Jul 12, 2010 3:16 pm Post subject: Comparison gaffe with data compression |
 |
|
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 |
|
 |
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Mon Mar 19, 2012 8:52 pm Post subject: |
|
|
This has now been fixed in SQL Compare 10.1 and can be downloaded through Help | 'Check for Updates'
_________________
Chris |
|
| Back to top |
|
|
|
|
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
