x

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

ALTER TABLE [CRDBO].[amortization] ADD CONSTRAINT [pk_amo] 
PRIMARY KEY CLUSTERED  ([id]) WITH(DATA_COMPRESSION=PAGE) ON [PRIMARY]
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

Håkan Winther gravatar image

Håkan Winther
15.6k 35 37 48

(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

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

Thank you for your effort! It is a major problem for our client, and any help is valuable.
Dec 02, 2009 at 07:18 PM Håkan Winther
(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1850
x131
x15
x13

asked: Nov 30, 2009 at 05:04 AM

Seen: 1877 times

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