参考会加入至资料库专案,您指定的那些物件和指令码则会修改为使用SETVAR变数,而不是使用伺服器和资料库名称。
The reference is added to the database project, and those objects and scripts that you specified are modified to use the SETVAR variables instead of the names of servers and databases.
指定必须在目的资料库中执行之指令码的路径,以部署结构描述变更或资料。
Specifies the path of a script that must run in the destination database in order to deploy schema changes or data.
当您执行此功能时,就会建立全新的DDL指令码,将会移除,然后重新建立所有资料库物件。
When you run the feature, it will create a completely new DDL script that will remove and then recreate all of the database objects.
此测试指令码会在执行内容权限等级执行,也就是在资料库上执行的使用者命令在一般使用情况下有效的相同权限等级。
The test script runs at the execution context permission level, which is the same permission level that would be in effect for user commands that are run on the database when it is in typical use.
假设此指令码包含单一资料库中的物件定义。
It is assumed that the script contains definitions for objects in a single database.
只要不信任来自任一使用者甚至是资料库的所有资讯,即可防止指令码遭到入侵。
You help guard against script exploits by not trusting any information that comes from a user or even from a database.
下表将提供与任何资料库单元测试有关的完整指令码清单。
The following table provides a complete list of scripts that are associated with any database unit test.
如果您要将具有多个资料库定义的指令码汇入到单一资料库专案中,您可能会收到大量的错误。
If you import a script that has multiple database definitions into a single database project, you might receive a significant number of errors.
否则您会想要事先备份资料或撰写指令码来重新产生测试资料的随时想修改模型并重新建立资料库结构描述。
Otherwise you'll want to either back up your data in advance or write a script to regenerate your test data any time you want to modify the model and recreate the database schema.
如果您有指定包含参考物件的资料库名称,在物件定义或指令码中,您可以包含其他资料库中的物件参考。
In object definitions or scripts, you can include references to objects in other databases if you specify the names of the databases that contain the objects to which you are referring.
这是根据设计的行为,因为每一个资料库专案只能有一个预先部署指令码和一个部署后指令码。
This behavior is by design because you can have only one pre-deployment and one post-deployment script for each database project.
所产生要用于部署结构描述的指令码,会包含完整的资料库结构描述。
Scripts that are generated to deploy the schema include the complete database schema.
资料库专案包含物件定义和部署指令码,可用来建立该资料库的新执行个体或更新现有执行个体。
A database project contains the object definitions and deployment scripts that you would need to create a separate instance of that database or to update an existing instance.
系统会剖析您所指定的指令码,而且会识别建立资料库物件的任何陈述式,并将这些陈述式汇入到资料库专案。
The script that you specified is parsed, and any statements that create database objects are identified and imported into the database project.
指令码使用暂存资料库连结来执行。
除了您可能会用来管理资料库或伺服器的任何指令码以外,专案还会包含预先部署和部署后指令码。
Your project contains pre-deployment and post-deployment scripts, in addition to any scripts that you might use to manage your database or server.
当您建置资料库专案时,所有包含的指令码会合并到建置指令码中。
When you build the database project, all included scripts are merged into the build script.
除了这三个动作以外,也有两个测试指令码(称为通用指令码)会在执行资料库单元测试的前后来执行。
In addition to these three actions, there are also two test scripts (referred to as common scripts), which run before and after a database unit test runs.
在对资料库执行这个指令码时,会在该资料库中重新建立资料库专案的结构。
This script, when it is run against a database, re-creates the structure of your database project in that database.
指定在部署流程期间于目的资料库中执行的指令码。
Specifies scripts that run in the destination database as part of the deployment process.
如果您尚未要更新资料库,可以选择储存变更指令码。
You might choose to save a change script if you are not ready to update the database.
如果您尚未要更新资料库,可以选择储存变更指令码。
You might choose to save a change script if you are not ready to update the database.
应用推荐