Red Gate forums :: View topic - 10.2.0.696 compression always ignored
Return to www.red-gate.com RSS Feed Available

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

10.2.0.696 compression always ignored

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ahribernik



Joined: 10 May 2012
Posts: 7

PostPosted: Wed May 23, 2012 4:09 am    Post subject: 10.2.0.696 compression always ignored Reply with quote

Upgraded to 10.2.0.696 and now compression seems to always be ignored regardless of the configuration setting.

source database has a table with PAGE compression on table and indexes target does not have compression.

source and target are SQL 2008 R2
red gate compare v10.2.0.696
ignore data compression is OFF
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Wed May 23, 2012 11:27 am    Post subject: Reply with quote

Hi ahribernik,

Sorry you are having a problem with Compare. I've been trying to recreate the issue you are reporting but to no avail.

I've tried with the following objects:

source

CREATE TABLE T1
(c1 int, c2 nvarchar(50) )
GO

CREATE NONCLUSTERED INDEX IX_INDEX_1
ON T1 (C2)
GO

and target


CREATE TABLE T1
(c1 int, c2 nvarchar(50) )
WITH (DATA_COMPRESSION = PAGE);
GO

CREATE NONCLUSTERED INDEX IX_INDEX_1
ON T1 (C2)
WITH ( DATA_COMPRESSION = PAGE ) ;
GO


and the ignore data compression option seems to work. Can you give me a specific example?

Thanks,
Neil
Back to top
View user's profile Send private message
ahribernik



Joined: 10 May 2012
Posts: 7

PostPosted: Thu May 24, 2012 2:56 am    Post subject: Reply with quote

Hi Niel, please try the reverse scenario with the source having compressed objects.
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Thu May 24, 2012 8:22 am    Post subject: Reply with quote

Hi ahribernik,

Thanks for your response. I'm still failing to reproduce the problem.

In your scenario are you using a saved project file from the previously released version of Compare? Does the problem persist if you create a new project or do a comparison without saving it as a project?

Thanks,
Neil
Back to top
View user's profile Send private message
ahribernik



Joined: 10 May 2012
Posts: 7

PostPosted: Fri May 25, 2012 2:34 am    Post subject: Reply with quote

Hi Niel,

I can repeat the behavior even with a new project

In an effort to provide you with a script I found out that this did not occur if i created 2 new databases and tables to compare.

I still however experience the problem with my existing database to a new target database.

Could this be a cache issue? Is it shared with SQL Source Control (I am experiencing a similar problem with that also)?
Back to top
View user's profile Send private message
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