Parse error in RedGate compare

I have a database with DATA_COMPRESSION=PAGE set on all tables and all indexes, and I generate object scripts to file with RedGate compare 8.0. The generated scripts looks like the one below:

CREATE TABLE [CRDBO].[amortization] ( [id] [int] NOT NULL IDENTITY(10000000, 1), [value_date] [datetime] NOT NULL, [pmnt_date] [datetime] NOT NULL, [pmnt_amount] [numeric] (28, 8) NULL, [pmnt_outstanding] [numeric] (28, 8) NULL, ) ON [PRIMARY] WITH (DATA_COMPRESSION = PAGE) GO


A completly valid SQL from what I can see, but Red-Gate Compare generates a parse error when I try to compare my scripts with a database. If I remove the DATA_COMPRESSION=Page option from the script and choose ignore "Data compression" when I compare everything works fine, besides that my data compression will vanish from the target database in the synchronization. Does anyone have another solution? Or does anyone know if Red-Gate are working on a fix? I have reported this as a bug and it is confirmed by Red-Gate, but I haven't seen any fix yet.

more ▼

asked Nov 30, 2009 at 05:04 AM in Default

avatar image

Håkan Winther
16.6k 37 46 58

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I've looked it up in our bug tracking system to see what the status is. Apparently fixing the problem is non-trivial. I believe that the fix is currently being targetted for the next major release, but I can't offer anything more concrete than that I'm afraid. I'll see if I can round up one of the team to drop by here and let you know a bit more detail.

more ▼

answered Dec 02, 2009 at 01:46 PM

avatar image

Melvyn Harbour 1 ♦♦
1.4k 19 40 26

(comments are locked)
10|1200 characters needed characters left

Best guess I can offer is to make sure you've got the latest version installed. They're up to 8.1.

more ▼

answered Nov 30, 2009 at 11:55 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 30, 2009 at 05:04 AM

Seen: 2124 times

Last Updated: Nov 30, 2009 at 05:04 AM

Copyright 2018 Redgate Software. Privacy Policy