|
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:
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.
(comments are locked)
|
|
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. Thank you for your effort! It is a major problem for our client, and any help is valuable.
Dec 02 '09 at 07:18 PM
Håkan Winther
(comments are locked)
|
|
Best guess I can offer is to make sure you've got the latest version installed. They're up to 8.1.
(comments are locked)
|

