10.2.0.696 compression always ignored

[ahribernik]

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

[neil.anderson]

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

[ahribernik]

Hi Niel, please try the reverse scenario with the source having compressed objects.

[neil.anderson]

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

[ahribernik]

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