10.2.0.696 compression always ignored

• 
  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

  neil.anderson May 23, 2012 06:27

  - 0 +
• 
  Hi Niel, please try the reverse scenario with the source having compressed objects.

  ahribernik May 23, 2012 21:56

  - 0 +
• 
  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

  neil.anderson May 24, 2012 03:22

  - 0 +
• 
  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)?

  ahribernik May 24, 2012 21:34

  - 0 +

Add comment

Please sign in to leave a comment.