[SSDT] Schema comparison (sqlpackage) and DATA_COMPRESSSION by Dave_Ballantyne

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	773928
Opened:	12/10/2012 4:25:00 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

If i declare a table inside SSDT without DATA_COMPRESSION
and then compare the dacpac against a database that has DATA_COMPRESSION set on that table, SSDT will report this as a change.

This happens even with the /p:IgnoreTableOptions=true option set.
As a suggestion : Add a new ignore option to make it more explicit rather than a generic "Table Option" ?

Details (expand)

English

SQL Server 2012 - Standard Edition

Developer Tools (SSDT, BIDS, etc.)

Not Applicable

As above

as above

X64

Other (e.g. VM Ware, specify in Description)

0 attachments

Posted by Microsoft on 1/16/2013 at 10:24 AM

Dave,

Thanks for the feedback regarding ignoring data compression options. There are actually two options that need to be set in order to ignore differences in data compression options. You will need to set both "Ignore Table Options" and "Ignore Index Options."

Let us know if you have any issues getting this approach to work.

Thanks,
Adam Mahood
Program Manager
SQL Server Database Systems

Microsoft