DACPAC 代表什么? [英] What does DACPAC stand for?

问题描述

在 Visual Studio 2012 中，我们有一个名为 SQL Server 数据库项目 的新项目类型，编译后将创建一个 .dacpac 输出文件.

In Visual Studio 2012 we have new project type called SQL Server Database Project and when compiled will create a .dacpac output file.

这个词的 Google 会将它与 Data-tier Application 相关联，但我无法将此名称与 D A C P A 和 C 相关联?

A Google for this term will link it with Data-tier Application but I cannot link this name with D A C P A and C?

dacpac 代表什么?

推荐答案

在文章 'It's Data Tier Application and Data Application Component' from December 23 2009 Microsoft 的 Buck Woody 声明 DAC 代表:

In the article 'It’s Data Tier Application and Data Application Component' from December 23 2009 Microsoft's Buck Woody states DAC stands for:

• Data A应用C组件

• Data Application Component

而且他还把结果作为一个包来讨论，所以猜测似乎是合理的:

And he also talks about the result as a package, so it seems reasonable to surmise:

• PAC 部分可能指的是 package.

• The PAC part probably refers to package.

这是相关的引用(相关部分用粗体表示，我的重点):

This is the relevant quote (relevant part in bold, my emphasis):

好的——在 SQL Server 2008 R2 中，我们确实重用"了一两个首字母缩略词(DAC 和DTA)，但重要的是要记住实际上有两个部分这个新功能.一个是数据应用组件 (DAC) 和另一个是数据层应用程序 (DTA).DAC 是创建的文件对于 DTA.

OK – In SQL Server 2008 R2 we did "re-use" an acronym or two (DAC and DTA), but it’s important to remember there are actually two parts to this new feature. One is the Data Application Component (DAC) and the other is the Data Tier Application (DTA). The DAC is the file created for a DTA.

在 SQL Server 2008R2 和 Visual Studio 中，您会发现有一种新方法编写和传输数据库代码.我会写更多关于它的博客完成我的测试，但过程有点像这样......

In SQL Server 2008R2 and Visual Studio you’ll find there is a new way to write and transfer database code. I’ll blog about it more as I finish my testing, but the process works kind of like this…

您可以在两个地方诞生"一个数据层应用程序.你可以创建Visual Studio 中的新项目类型，开发人员可以在其中创建数据库结构，放置他们想要执行的所有策略等等.DBA 还可以右键单击数据库并创建一个当前结构之外的数据层应用程序.

You can "birth" a Data Tier Application in two places. You can create a new project type in Visual Studio where the developer can create the database structure, put all of the policies that they want to enforce and so on there. The DBA can also right-click a database and make a Data Tier Application out of a current structure.

在这两种情况下，称为 DAC 或数据应用程序组件的东西- 被建造.这是一个包含主要部分的有效负载的文件数据库的结构等等.这就是您使用的包"转移DTA.

In both cases, something called a DAC – or Data Application Component – is created. It’s a file with the payload of the the major parts of the structure of the database and so on. that’s the "package" you use to transfer the DTA around.

从那里，您右键单击 SQL 中的数据层应用程序"节点另一个实例上的 Server Management Studio 并部署"数据层级应用.它将为您构建数据库并保留它一起作为 DTA.您可以在原始"系统中进行更改或代码，然后升级"数据层应用程序.

From there, you right-click in the "Data Tier Application" node in SQL Server Management Studio on another Instance and "Deploy" the Data Tier Application. It will build the database for you and keep it together as a DTA. You can make changes in the "originating" system or code, and then "upgrade" the Data Tier Application.

所以你有它.它是 DTA 和 DAC——但我想你会知道不同的时候使用一个......

So there you have it. It’s DTA and DAC – but I think you’ll know the difference when the time comes to use one…

这篇 InfoWorld 文章建议对上述内容略有不同，指出 DACPAC 部分代表:

This InfoWorld article suggests a slight variation on the above, stating that the DACPAC part stands for:

• Data-tier A应用C组件PACkages.

• Data-tier Application Component PACkages.

这篇关于DACPAC 代表什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！