有没有办法阻止 SqlPackage.exe 在部署脚本中设置默认文件组? [英] Is there any way to stop SqlPackage.exe setting default Filegroup in deployment script?

问题描述

我们正在使用 Sql Server 数据库项目通过 SqlPackage.exe 从 DacPac 创建部署脚本.我们在各种环境中设置了不同的 SQL Server 文件组.部署时，我们排除文件组，因为我们希望在默认文件组中创建对象.在数据库项目设置中，默认文件组不会从 PRIMARY 更改.

We are using Sql Server database projects to create deployment scripts from DacPac using SqlPackage.exe. We have different SQL Server Filegroups setup in various environments. When deploying we exclude Filegroups as we want objects to create in the default Filegroup. In database project settings the default Filegroup is not changed from PRIMARY.

尝试部署到默认文件组不是 PRIMARY 的环境时会出现问题，因为包含以下代码...

This presents a problem when attempting to deploy to an environment where the default Filegroup is not PRIMARY because the following code is included...

ALTER DATABASE [$(DatabaseName)]
    MODIFY FILEGROUP [PRIMARY] DEFAULT;

有没有办法防止这种情况在部署 SQL 中生成?

Is there a way to prevent this from generating in the deployment SQL?

推荐答案

我不知道您是否可以在 SSDT 中禁用它.

I don't know if you can disable it within SSDT.

但是您可以使用部署计划贡献者来过滤出 MODIFY FILEGROUP 语句或按照您想要的方式更改它.您可以在此处找到详细说明和工作代码:http://scardevblog.blogspot.com/2015/03/ssdt-generates-2012-option-for-target.html

But you can use deployment plan contributor to filter out MODIFY FILEGROUP statement or to change it the way you want. You can find detailed instructions and working code here: http://scardevblog.blogspot.com/2015/03/ssdt-generates-2012-option-for-target.html

这篇关于有没有办法阻止 SqlPackage.exe 在部署脚本中设置默认文件组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！