SQL Server Entity Framework code first DATA_COMPRESSION=PAGE

lztngnrs 于 12个月前发布在其他

关注(0)|答案(1)|浏览(91)

I'm using Entity Framework code-first with migrations. Works great but I would like all SQL Server tables created to have the DATA_COMPRESSION=PAGE option.

What would be the best approach to do that?

sql-server

来源：https://stackoverflow.com/questions/77757616/entity-framework-code-first-data-compression-page

1条答案

按热度按时间

ohfgkhjo1#

You can do with with a Custom Migration Operation that rebuilds the selected tables with page compression, eg

ALTER TABLE [Whatever] REBUILD WITH (DATA_COMPRESSION = PAGE)

赞(0）回复(0）举报 12个月前

我来回答

SQL Server Entity Framework code first DATA_COMPRESSION=PAGE

1条答案

相关问题

热门标签

最新问答