SqlPackage.exeSqlPackage.exe

SqlPackage.exe 是命令列公用程式,可自動化下列資料庫開發工作:SqlPackage.exe is a command-line utility that automates the following database development tasks:

  • Extract:從即時的 SQL Server 或 Azure SQL Database 建立資料庫快照集 (.dacpac) 檔案。Extract: Creates a database snapshot (.dacpac) file from a live SQL Server or Azure SQL Database.

  • Publish:累加更新資料庫結構描述以符合來源 .dacpac 檔案的結構描述。Publish: Incrementally updates a database schema to match the schema of a source .dacpac file. 如果資料庫不存在伺服器上,發行作業會加以建立。If the database does not exist on the server, the publish operation creates it. 否則,會更新現有的資料庫。Otherwise, an existing database is updated.

  • Export:將即時資料庫 (包括資料庫結構描述和使用者資料) 從 SQL Server 或 Azure SQL Database 匯出到 BACPAC 套件 (.bacpac 檔案)。Export: Exports a live database - including database schema and user data - from SQL Server or Azure SQL Database to a BACPAC package (.bacpac file).

  • Import:將結構描述和資料表資料從 BACPAC 套件匯入至 SQL Server 或 Azure SQL Database 執行個體中的新使用者資料庫。Import: Imports the schema and table data from a BACPAC package into a new user database in an instance of SQL Server or Azure SQL Database.

  • DeployReport:建立發行動作所做變更的 XML 報表。DeployReport: Creates an XML report of the changes that would be made by a publish action.

  • DriftReport:建立自從上次註冊以來已經對註冊資料庫所做變更的 XML 報表。DriftReport: Creates an XML report of the changes that have been made to a registered database since it was last registered.

  • Script:建立 Transact-SQL 累加更新指令碼,這個指令碼會更新目標的結構描述以符合來源的結構描述。Script: Creates a Transact-SQL incremental update script that updates the schema of a target to match the schema of a source.

SqlPackage.exe 命令列可讓您指定這些動作以及動作特有的參數和屬性。The SqlPackage.exe command line allows you to specify these actions along with action-specific parameters and properties.

下載最新版本Download the latest version. 如需最新版本的詳細資訊,請參閱版本資訊For details about the latest release, see the release notes.

命令列語法Command-Line Syntax

SqlPackage.exe 會使用命令列上指定的參數、屬性和 SQLCMD 變數來起始指定的動作。SqlPackage.exe initiates the actions specified using the parameters, properties, and SQLCMD variables specified on the command line.

SqlPackage {parameters}{properties}{SQLCMD Variables}  

Extract 動作的說明Help for the Extract action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a ExtractExtract 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property; {PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/ SourceConnectionString:/SourceConnectionString: /scs/scs {string}{string} 指定來源資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the source database. 如果指定了此參數,就應該以獨佔方式將其用於所有其他來源參數。If this parameter is specified, it shall be used exclusively of all other source parameters.
/SourceDatabaseName:/SourceDatabaseName: /sdn/sdn {string}{string} 定義來源資料庫的名稱。Defines the name of the source database.
/SourceEncryptConnection:/SourceEncryptConnection: /sec/sec {True|False}{True|False} 指定 SQL 加密是否應該用於來源資料庫連接。Specifies if SQL encryption should be used for the source database connection.
/SourcePassword:/SourcePassword: /sp/sp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the source database.
/ SourceServerName:/SourceServerName: /ssn/ssn {string}{string} 定義裝載來源資料庫的伺服器名稱。Defines the name of the server hosting the source database.
/ SourceTimeout:/SourceTimeout: /st/st {int}{int} 指定建立來源資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the source database in seconds.
/SourceTrustServerCertificate:/SourceTrustServerCertificate: /stsc/stsc {True|False}{True|False} 指定是否要使用 SSL 來加密來源資料庫連線並且略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the source database connection and bypass walking the certificate chain to validate trust.
/SourceUser:/SourceUser: /su/su {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the source database.
/TargetFile:/TargetFile: /tf/tf {string}{string} 指定要做為目標的動作,而不是資料庫的目標檔案 (亦即.dacpac 檔案)。Specifies a target file (that is, a .dacpac file) to be used as the target of action instead of a database. 如果使用此參數,其他目標參數都應該無效。If this parameter is used, no other target parameter shall be valid. 此參數應僅支援資料庫目標的動作無效。This parameter shall be invalid for actions that only support database targets.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).

擷取動作特有的屬性Properties specific to the Extract action

屬性Property ReplTest1Value DescriptionDescription
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: DacApplicationDescription=(STRING)DacApplicationDescription=(STRING) 定義要儲存在 DACPAC 中繼資料中的應用程式描述。Defines the Application description to be stored in the DACPAC metadata.
/p:/p: DacApplicationName=(STRING)DacApplicationName=(STRING) 定義要儲存在 DACPAC 中繼資料中的應用程式名稱。Defined the Application name to be stored in the DACPAC metadata. 預設值為資料庫名稱。The default value is the database name.
/p:/p: DacMajorVersion=(INT32 '1')DacMajorVersion=(INT32 '1') 定義要儲存在 DACPAC 中繼資料中的主要版本。Defines the major version to be stored in the DACPAC metadata.
/p:/p: DacMinorVersion=(INT32 '0')DacMinorVersion=(INT32 '0') 定義要儲存在 DACPAC 中繼資料中的次要版本。Defines the minor version to be stored in the DACPAC metadata.
/p:/p: ExtractAllTableData=(BOOLEAN)ExtractAllTableData=(BOOLEAN) 指出是否要擷取所有使用者資料表的資料。Indicates whether data from all user tables is extracted. 如果為 'true',擷取所有使用者資料表的資料時,,而且您無法指定個別使用者資料表擷取資料。If 'true', data from all user tables is extracted, and you cannot specify individual user tables for extracting data. 如果為 'false',指定要從中擷取資料的一或多個使用者資料表。If 'false', specify one or more user tables to extract data from.
/p:/p: ExtractApplicationScopedObjectsOnly=(BOOLEAN 'True')ExtractApplicationScopedObjectsOnly=(BOOLEAN 'True') 如果為 true,則只擷取指定之來源的應用程式範圍物件。If true, only extract application-scoped objects for the specified source. 如果為 false,則擷取指定之來源的所有物件。If false, extract all objects for the specified source.
/p:/p: ExtractReferencedServerScopedElements=(BOOLEAN 'True')ExtractReferencedServerScopedElements=(BOOLEAN 'True') 如果為 true,則擷取來源資料庫物件所參考的登入、伺服器稽核及認證物件。If true, extract login, server audit, and credential objects referenced by source database objects.
/p:/p: ExtractUsageProperties=(BOOLEAN)ExtractUsageProperties=(BOOLEAN) 指定是否會從資料庫擷取用法屬性,例如資料表資料列計數和索引大小。Specifies whether usage properties, such as table row count and index size, will be extracted from the database.
/p:/p: IgnoreExtendedProperties=(BOOLEAN)IgnoreExtendedProperties=(BOOLEAN) 指定是否應該忽略擴充屬性。Specifies whether extended properties should be ignored.
/p:/p: IgnorePermissions=(BOOLEAN 'True')IgnorePermissions=(BOOLEAN 'True') 指定是否應該忽略權限。Specifies whether permissions should be ignored.
/p:/p: IgnoreUserLoginMappings=(BOOLEAN)IgnoreUserLoginMappings=(BOOLEAN) 指定是否忽略使用者與登入之間的關聯性。Specifies whether relationships between users and logins are ignored.
/p:/p: Storage=({File|Memory} 'File')Storage=({File|Memory} 'File') 指定支援儲存體的類型,以供結構描述模型在擷取期間使用。Specifies the type of backing storage for the schema model used during extraction.
/p:/p: TableData=(STRING)TableData=(STRING) 指出擷取資料的資料表。Indicates the table from which data will be extracted. 指定的資料表名稱,包含或不含方括號名稱部分,以下列格式: schema_name.table_identifier。Specify the table name with or without the brackets surrounding the name parts in the following format: schema_name.table_identifier.
/p:/p: VerifyExtraction=(BOOLEAN)VerifyExtraction=(BOOLEAN) 指定是否應該驗證擷取的 dacpac。Specifies whether the extracted dacpac should be verified.

Publish 參數、屬性與 SQLCMD 變數Publish Parameters, Properties, and SQLCMD Variables

SqlPackage.exe 發行作業會累加更新目標資料庫的結構描述,使其符合來源資料庫的結構。A SqlPackage.exe publish operation incrementally updates the schema of a target database to match the structure of a source database. 發行部署套件時,若其中包含所有資料表或資料表子集的使用者資料,則除了結構描述以外,也會更新資料表資料。Publishing a deployment package that contains user data for all or a subset of tables update the table data in addition to the schema. 資料部署會覆寫目標資料庫之現有資料表中的結構描述和資料。Data deployment overwrites the schema and data in existing tables of the target database. 對於未包括在部署套件的資料表,資料部署將不會變更目標資料庫中的現有結構描述或資料。Data deployment will not change existing schema or data in the target database for tables not included in the deployment package.

發行動作的說明Help for Publish action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a 發行Publish 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/AzureKeyVaultAuthMethod:/AzureKeyVaultAuthMethod: /akv/akv {Interactive|ClientIdSecret}{Interactive|ClientIdSecret} 指定存取 Azure Key Vault 時要使用的驗證方法Specifies what authentication method is used for accessing Azure KeyVault
/ClientId:/ClientId: /cid/cid {string}{string} 指定必要時驗證 Azure Key Vault 所要使用的用戶端識別碼Specifies the Client ID to be used in authenticating against Azure KeyVault, when necessary
/DeployScriptPath:/DeployScriptPath: /dsp/dsp {string}{string} 指定選擇性檔案路徑來輸出部署指令碼。Specifies an optional file path to output the deployment script. 對於 Azure 部署,若有 TSQL 命令要建立或修改 master 資料庫,將會對指令碼寫入相同的路徑,但會使用 "Filename_Master.sql" 做為輸出檔案名稱。For Azure deployments, if there are TSQL commands to create or modify the master database, a script will be written to the same path but with "Filename_Master.sql" as the output file name.
/DeployReportPath:/DeployReportPath: /drp/drp {string}{string} 指定選擇性檔案路徑來輸出部署報表 XML 檔案。Specifies an optional file path to output the deployment report xml file.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Profile:/Profile: /pr/pr {string}{string} 指定 DAC 發行設定檔的檔案路徑。Specifies the file path to a DAC Publish Profile. 設定檔會定義產生輸出時要使用之屬性及變數的集合。The profile defines a collection of properties and variables to use when generating outputs.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property;{PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/Secret:/Secret: /secr/secr {string}{string} 指定必要時驗證 Azure Key Vault 所要使用的用戶端密碼Specifies the Client Secret to be used in authenticating against Azure KeyVault, when necessary
/ SourceConnectionString:/SourceConnectionString: /scs/scs {string}{string} 指定來源資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the source database. 如果指定了此參數,就應該以獨佔方式將其用於所有其他來源參數。If this parameter is specified, it shall be used exclusively of all other source parameters.
/SourceDatabaseName:/SourceDatabaseName: /sdn/sdn {string}{string} 定義來源資料庫的名稱。Defines the name of the source database.
/SourceEncryptConnection:/SourceEncryptConnection: /sec/sec {True|False}{True|False} 指定 SQL 加密是否應該用於來源資料庫連接。Specifies if SQL encryption should be used for the source database connection.
/Sourcefile:/SourceFile: /sf/sf {string}{string} 指定要當作動作來源使用的來源檔案,而非資料庫。Specifies a source file to be used as the source of action instead of a database. 如果使用了此參數,其他來源參數都應該無效。If this parameter is used, no other source parameter shall be valid.
/SourcePassword:/SourcePassword: /sp/sp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the source database.
/ SourceServerName:/SourceServerName: /ssn/ssn {string}{string} 定義裝載來源資料庫的伺服器名稱。Defines the name of the server hosting the source database.
/ SourceTimeout:/SourceTimeout: /st/st {int}{int} 指定建立來源資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the source database in seconds.
/SourceTrustServerCertificate:/SourceTrustServerCertificate: /stsc/stsc {True|False}{True|False} 指定是否要使用 SSL 來加密來源資料庫連線並且略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the source database connection and bypass walking the certificate chain to validate trust.
/SourceUser:/SourceUser: /su/su {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the source database.
/ TargetConnectionString:/TargetConnectionString: /tcs/tcs {string}{string} 指定目標資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the target database. 如果指定此參數,就應該以獨佔方式將它用於所有其他目標參數。If this parameter is specified, it shall be used exclusively of all other target parameters.
/TargetDatabaseName:/TargetDatabaseName: /tdn/tdn {string}{string} 指定 sqlpackage.exe 動作目標之資料庫名稱的覆寫。Specifies an override for the name of the database that is the target of sqlpackage.exe Action.
/TargetEncryptConnection:/TargetEncryptConnection: /tec/tec {True|False}{True|False} 指定 SQL 加密是否應該用於目標資料庫連線。Specifies if SQL encryption should be used for the target database connection.
/ TargetPassword:/TargetPassword: /tp/tp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取目標資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the target database.
/ TargetServerName:/TargetServerName: /tsn/tsn {string}{string} 定義裝載目標資料庫的伺服器名稱。Defines the name of the server hosting the target database.
/TargetTimeout:/TargetTimeout: /tt/tt {int}{int} 指定建立目標資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the target database in seconds. Azure AD 中,建議您使用這個值是大於或等於為 30 秒。For Azure AD, it is recommended that this value be greater than or equal to 30 seconds.
/TargetTrustServerCertificate:/TargetTrustServerCertificate: /ttsc/ttsc {True|False}{True|False} 指定是否要使用 SSL 來加密目標資料庫連線並略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the target database connection and bypass walking the certificate chain to validate trust.
/ TargetUser:/TargetUser: /tu/tu {string}{string} 若為 SQL Server 驗證案例,則定義要用以存取目標資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/Variables:/Variables: /v/v {PropertyName}={Value}{PropertyName}={Value} 指定動件特定變數的名稱/值對:{VariableName}={Value}。Specifies a name value pair for an action-specific variable;{VariableName}={Value}. DACPAC 檔案包含有效 SQLCMD 變數的清單。The DACPAC file contains the list of valid SQLCMD variables. 如果未針對每一個變數提供值,則會產生錯誤。An error results if a value is not provided for every variable.

發行動作的特定屬性Properties specific to the Publish action

屬性Property ReplTest1Value DescriptionDescription
/p:/p: AdditionalDeploymentContributorArguments=(STRING)AdditionalDeploymentContributorArguments=(STRING) 為部署參與者指定其他部署參與者引數。Specifies additional deployment contributor arguments for the deployment contributors. 這應該是以分號區隔的值清單。This should be a semi-colon delimited list of values.
/p:/p: AdditionalDeploymentContributors=(STRING)AdditionalDeploymentContributors=(STRING) 指定部署 dacpac 時應該執行的其他部署參與者。Specifies additional deployment contributors, which should run when the dacpac is deployed. 這應該是以分號區隔的完整組建參與者名稱或識別碼清單。This should be a semi-colon delimited list of fully qualified build contributor names or IDs.
/p:/p: AllowDropBlockingAssemblies=(BOOLEAN)AllowDropBlockingAssemblies=(BOOLEAN) 這個屬性是供 SqlClr 部署用來使任何封鎖的組件會在部署計畫中卸除。This property is used by SqlClr deployment to cause any blocking assemblies to be dropped as part of the deployment plan. 根據預設,如果必須卸除任何參考組件,則該封鎖/參考組件會封鎖組件更新。By default, any blocking/referencing assemblies will block an assembly update if the referencing assembly needs to be dropped.
/p:/p: AllowIncompatiblePlatform=(BOOLEAN)AllowIncompatiblePlatform=(BOOLEAN) 指定儘管 SQL Server 平台不相容,是否仍要嘗試動作。Specifies whether to attempt the action despite incompatible SQL Server platforms.
/p:/p: AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN)AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN) 若此屬性設定為 true,請勿封鎖具有資料列層級安全性之資料表的資料動作。Do not block data motion on a table that has Row Level Security if this property is set to true. 預設值為 false。Default is false.
/p:/p: BackupDatabaseBeforeChanges=(BOOLEAN)BackupDatabaseBeforeChanges=(BOOLEAN) 在部署任何變更之前,先備份資料庫。Backups the database before deploying any changes.
/p:/p: BlockOnPossibleDataLoss=(BOOLEAN 'True')BlockOnPossibleDataLoss=(BOOLEAN 'True') 指定如果發行作業可能導致資料遺失,就應該終止發行事件。Specifies that the publish episode should be terminated if there is a possibility of data loss resulting from the publish.operation.
/p:/p: BlockWhenDriftDetected=(BOOLEAN 'True')BlockWhenDriftDetected=(BOOLEAN 'True') 指定是否封鎖更新結構描述不再符合註冊或已取消註冊的資料庫。Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: CommentOutSetVarDeclarations=(BOOLEAN)CommentOutSetVarDeclarations=(BOOLEAN) 指定在產生的發行指令碼中是否應該將 SETVAR 變數的宣告標記為註解。Specifies whether the declaration of SETVAR variables should be commented out in the generated publish script. 如果您計畫在使用 SQLCMD.EXE 等工具進行發行時在命令列指定值,就可以選擇這種作法。You might choose to do this if you plan to specify the values on the command line when you publish by using a tool such as SQLCMD.EXE.
/p:/p: CompareUsingTargetCollation=(BOOLEAN)CompareUsingTargetCollation=(BOOLEAN) 這個設定表示資料庫的定序於部署期間的處理方式。如果目標資料庫的定序不符合來源所指定的定序,預設會更新目標資料庫的定序。This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. 當設定這個選項時,則應該使用目標資料庫 (或伺服器) 的定序。When this option is set, the target database's (or server's) collation should be used.
/p:/p: CreateNewDatabase=(BOOLEAN)CreateNewDatabase=(BOOLEAN) 指定當您發行至資料庫時,應該更新目標資料庫或應該卸除並重新建立目標資料庫。Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.
/p:/p: DatabaseEdition=({Basic|Standard|Premium|Default} 'Default')DatabaseEdition=({Basic|Standard|Premium|Default} 'Default') 定義 Azure SQL Database 的版本。Defines the edition of an Azure SQL Database.
/p:/p: DatabaseMaximumSize=(INT32)DatabaseMaximumSize=(INT32) 定義 Azure SQL Database 的大小上限 (以 GB 表示)。Defines the maximum size in GB of an Azure SQL Database.
/p:/p: DatabaseServiceObjective=(STRING)DatabaseServiceObjective=(STRING) 定義 Azure SQL Database 的效能等級,例如 "P0" 或 "S1"。Defines the performance level of an Azure SQL Database such as"P0" or "S1".
/p:/p: DeployDatabaseInSingleUserMode=(BOOLEAN)DeployDatabaseInSingleUserMode=(BOOLEAN) 若為 true,則資料庫會在設定為單一使用者模式後部署。if true, the database is set to Single User Mode before deploying.
/p:/p: DisableAndReenableDdlTriggers=(BOOLEAN 'True')DisableAndReenableDdlTriggers=(BOOLEAN 'True') 指定是否在發行程序開始時停用資料定義語言 (DDL) 觸發程序,並在發行動作結束時重新啟用。Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.
/p:/p: DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True')DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True') 如果為 true,則不會改變異動資料擷取物件。If true, Change Data Capture objects are not altered.
/p:/p: DoNotAlterReplicatedObjects=(BOOLEAN 'True')DoNotAlterReplicatedObjects=(BOOLEAN 'True') 指定驗證期間是否識別有複寫的物件。Specifies whether objects that are replicated are identified during verification.
/p:/p: DoNotDropObjectType=(STRING)DoNotDropObjectType=(STRING) 物件型別,不應該捨棄當 DropObjectsNotInSource 為 true。An object type that should not be dropped when DropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DoNotDropObjectTypes=(STRING)DoNotDropObjectTypes=(STRING) 當 DropObjectsNotInSource 為 true 時不應捨棄的分號分隔物件類型清單。A semicolon-delimited list of object types that should not be dropped when DropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DropConstraintsNotInSource=(BOOLEAN 'True')DropConstraintsNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的條件約束。Specifies whether constraints that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropDmlTriggersNotInSource=(BOOLEAN 'True')DropDmlTriggersNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的 DML 觸發程序。Specifies whether DML triggers that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropExtendedPropertiesNotInSource=(BOOLEAN 'True')DropExtendedPropertiesNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的擴充屬性。Specifies whether extended properties that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropIndexesNotInSource=(BOOLEAN 'True')DropIndexesNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的索引。Specifies whether indexes that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropObjectsNotInSource=(BOOLEAN)DropObjectsNotInSource=(BOOLEAN) 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的物件。Specifies whether objects that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database. 此值的優先順序高過 DropExtendedProperties。This value takes precedence over DropExtendedProperties.
/p:/p: DropPermissionsNotInSource=(BOOLEAN)DropPermissionsNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的權限。Specifies whether permissions that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropRoleMembersNotInSource=(BOOLEAN)DropRoleMembersNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除資料庫快照集 (.dacpac) 檔案中沒有定義的角色成員。Specifies whether role members that are not defined in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropStatisticsNotInSource=(BOOLEAN 'True')DropStatisticsNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫卸除不存在於資料庫快照集 (.dacpac) 檔案中的統計資料。Specifies whether statistics that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: ExcludeObjectType=(STRING)ExcludeObjectType=(STRING) 部署期間應該忽略的物件類型。An object type that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: ExcludeObjectTypes=(STRING)ExcludeObjectTypes=(STRING) 以分號區隔的物件類型清單,列出部署期間應該忽略的物件類型。A semicolon-delimited list of object types that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: GenerateSmartDefaults=(BOOLEAN)GenerateSmartDefaults=(BOOLEAN) 在更新含有資料且資料行不允許 null 值的資料表時,自動提供預設值。Automatically provides a default value when updating a table that contains data with a column that does not allow null values.
/p:/p: IgnoreAnsiNulls=(BOOLEAN 'True')IgnoreAnsiNulls=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 ANSI NULLS 設定的差異。Specifies whether differences in the ANSI NULLS setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreAuthorizer=(BOOLEAN)IgnoreAuthorizer=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新授權者的差異。Specifies whether differences in the Authorizer should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnCollation=(BOOLEAN)IgnoreColumnCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料行定序的差異。Specifies whether differences in the column collations should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnOrder=(BOOLEAN)IgnoreColumnOrder=(BOOLEAN) 指定當您發行至資料庫時,是否應略過或更新資料表資料行順序的差異。Specifies whether differences in table column order should be ignored or updated when you publish to a database.
/p:/p: IgnoreComments=(BOOLEAN)IgnoreComments=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新註解的差異。Specifies whether differences in the comments should be ignored or updated when you publish to a database.
/p:/p: IgnoreCryptographicProviderFilePath=(BOOLEAN 'True')IgnoreCryptographicProviderFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新密碼編譯提供者之檔案路徑的差異。Specifies whether differences in the file path for the cryptographic provider should be ignored or updated when you publish to a database.
/p:/p: IgnoreDdlTriggerOrder=(BOOLEAN)IgnoreDdlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫或伺服器時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序的順序差異。Specifies whether differences in the order of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database or server.
/p:/p: IgnoreDdlTriggerState=(BOOLEAN)IgnoreDdlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDefaultSchema=(BOOLEAN)IgnoreDefaultSchema=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新預設結構描述的差異。Specifies whether differences in the default schema should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerOrder=(BOOLEAN)IgnoreDmlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料操作語言 (DML) 觸發程序的順序差異。Specifies whether differences in the order of Data Manipulation Language (DML) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerState=(BOOLEAN)IgnoreDmlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新 DML 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of DML triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreExtendedProperties=(BOOLEAN)IgnoreExtendedProperties=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新擴充屬性的差異。Specifies whether differences in the extended properties should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileAndLogFilePath=(BOOLEAN 'True')IgnoreFileAndLogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新檔案和記錄檔之路徑的差異。Specifies whether differences in the paths for files and log files should be ignored or updated when you publish to a database.
/p:/p: IgnoreFilegroupPlacement=(BOOLEAN 'True')IgnoreFilegroupPlacement=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 FILEGROUP 中物件位置的差異。Specifies whether differences in the placement of objects in FILEGROUPs should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileSize=(BOOLEAN 'True')IgnoreFileSize=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略檔案大小的差異或應該發出警告。Specifies whether differences in the file sizes should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreFillFactor=(BOOLEAN 'True')IgnoreFillFactor=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略索引儲存體之填滿因數的差異或應該發出警告。Specifies whether differences in the fill factor for index storage should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreFullTextCatalogFilePath=(BOOLEAN 'True')IgnoreFullTextCatalogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略全文檢索目錄之檔案路徑的差異或應該發出警告。Specifies whether differences in the file path for the full-text catalog should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreIdentitySeed=(BOOLEAN)IgnoreIdentitySeed=(BOOLEAN) 指定當您發行更新至資料庫時,應該忽略或更新識別欄位之種子的差異。Specifies whether differences in the seed for an identity column should be ignored or updated when you publish updates to a database.
/p:/p: IgnoreIncrement=(BOOLEAN)IgnoreIncrement=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新識別欄位之增量的差異。Specifies whether differences in the increment for an identity column should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexOptions=(BOOLEAN)IgnoreIndexOptions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引選項的差異。Specifies whether differences in the index options should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexPadding=(BOOLEAN 'True')IgnoreIndexPadding=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新索引填補的差異。Specifies whether differences in the index padding should be ignored or updated when you publish to a database.
/p:/p: IgnoreKeywordCasing=(BOOLEAN 'True')IgnoreKeywordCasing=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新關鍵字之大小寫的差異。Specifies whether differences in the casing of keywords should be ignored or updated when you publish to a database.
/p:/p: IgnoreLockHintsOnIndexes=(BOOLEAN)IgnoreLockHintsOnIndexes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引之鎖定提示的差異。Specifies whether differences in the lock hints on indexes should be ignored or updated when you publish to a database.
/p:/p: IgnoreLoginSids=(BOOLEAN 'True')IgnoreLoginSids=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新安全性識別碼 (SID) 的差異。Specifies whether differences in the security identification number (SID) should be ignored or updated when you publish to a database.
/p:/p: IgnoreNotForReplication=(BOOLEAN)IgnoreNotForReplication=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新不可複寫設定。Specifies whether the not for replication settings should be ignored or updated when you publish to a database.
/p:/p: IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True')IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新物件在資料分割配置上的位置。Specifies whether an object's placement on a partition scheme should be ignored or updated when you publish to a database.
/p:/p: IgnorePartitionSchemes=(BOOLEAN)IgnorePartitionSchemes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料分割配置和函式的差異。Specifies whether differences in partition schemes and functions should be ignored or updated when you publish to a database.
/p:/p: IgnorePermissions=(BOOLEAN)IgnorePermissions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新權限的差異。Specifies whether differences in the permissions should be ignored or updated when you publish to a database.
/p:/p: IgnoreQuotedIdentifiers=(BOOLEAN 'True')IgnoreQuotedIdentifiers=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新引號識別項設定的差異。Specifies whether differences in the quoted identifiers setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreRoleMembership=(BOOLEAN)IgnoreRoleMembership=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新登入之角色成員資格的差異。Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.
/p:/p: IgnoreRouteLifetime=(BOOLEAN 'True')IgnoreRouteLifetime=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 SQL Server 將路由保留在路由表中之時間長短的差異。Specifies whether differences in the amount of time that SQL Server retains the route in the routing table should be ignored or updated when you publish to a database.
/p:/p: IgnoreSemicolonBetweenStatements=(BOOLEAN 'True')IgnoreSemicolonBetweenStatements=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 T-SQL 陳述式間之分號的差異。Specifies whether differences in the semi-colons between T-SQL statements will be ignored or updated when you publish to a database.
/p:/p: IgnoreTableOptions=(BOOLEAN)IgnoreTableOptions=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新資料表選項的差異。Specifies whether differences in the table options will be ignored or updated when you publish to a database.
/p:/p: IgnoreUserSettingsObjects=(BOOLEAN)IgnoreUserSettingsObjects=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新使用者設定物件的差異。Specifies whether differences in the user settings objects will be ignored or updated when you publish to a database.
/p:/p: IgnoreWhitespace=(BOOLEAN 'True')IgnoreWhitespace=(BOOLEAN 'True') 指定當您發行至資料庫時,將忽略或更新空白字元的差異。Specifies whether differences in white space will be ignored or updated when you publish to a database.
/p:/p: IgnoreWithNocheckOnCheckConstraints=(BOOLEAN)IgnoreWithNocheckOnCheckConstraints=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新檢查條件約束之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for check constraints will be ignored or updated when you publish.
/p:/p: IgnoreWithNocheckOnForeignKeys=(BOOLEAN)IgnoreWithNocheckOnForeignKeys=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新外部索引鍵之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for foreign keys will be ignored or updated when you publish to a database.
/p:/p: IncludeCompositeObjects=(BOOLEAN)IncludeCompositeObjects=(BOOLEAN) 將所有複合項目包含在單一發行作業中。Include all composite elements as part of a single publish operation.
/p:/p: IncludeTransactionalScripts=(BOOLEAN)IncludeTransactionalScripts=(BOOLEAN) 指定當您發行至資料庫時,是否應該盡可能使用交易陳述式。Specifies whether transactional statements should be used where possible when you publish to a database.
/p:/p: NoAlterStatementsToChangeClrTypes=(BOOLEAN)NoAlterStatementsToChangeClrTypes=(BOOLEAN) 指定發行在發現差異時一定要卸除並重新建立組件,而不是發出 ALTER ASSEMBLY 陳述式。Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.
/p:/p: PopulateFilesOnFileGroups=(BOOLEAN 'True')PopulateFilesOnFileGroups=(BOOLEAN 'True') 指定在目標資料庫中建立新 FileGroup 時,是否一併建立新檔案。Specifies whether a new file is also created when a new FileGroup is created in the target database.
/p:/p: RegisterDataTierApplication=(BOOLEAN)RegisterDataTierApplication=(BOOLEAN) 指定結構描述是否向資料庫伺服器註冊。Specifies whether the schema is registered with the database server.
/p:/p: RunDeploymentPlanExecutors=(BOOLEAN)RunDeploymentPlanExecutors=(BOOLEAN) 指定執行其他作業時,是否應該執行 DeploymentPlanExecutor 參與者。Specifies whether DeploymentPlanExecutor contributors should be run when other operations are executed.
/p:/p: ScriptDatabaseCollation=(BOOLEAN)ScriptDatabaseCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫定序的差異。Specifies whether differences in the database collation should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseCompatibility=(BOOLEAN)ScriptDatabaseCompatibility=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫相容性的差異。Specifies whether differences in the database compatibility should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseOptions=(BOOLEAN 'True')ScriptDatabaseOptions=(BOOLEAN 'True') 指定是否應該在發行動作中設定或更新目標資料庫屬性。Specifies whether target database properties should be set or updated as part of the publish action.
/p:/p: ScriptDeployStateChecks=(BOOLEAN)ScriptDeployStateChecks=(BOOLEAN) 指定是否在發行指令碼中產生陳述式,來驗證資料庫名稱和伺服器名稱是否符合資料庫專案中指定的名稱。Specifies whether statements are generated in the publish script to verify that the database name and server name match the names specified in the database project.
/p:/p: ScriptFileSize=(BOOLEAN)ScriptFileSize=(BOOLEAN) 控制將檔案加入至檔案群組時是否指定大小。Controls whether size is specified when adding a file to a filegroup.
/p:/p: ScriptNewConstraintValidation=(BOOLEAN 'True')ScriptNewConstraintValidation=(BOOLEAN 'True') 在發行結束時,所有會驗證條件約束當做單一集合,避免檢查或外部索引鍵條件約束在發行所造成的資料錯誤。At the end of publish all of the constraints will be verified as one set, avoiding data errors caused by a check or foreign key constraint in the middle of publish. 如果設為 False,則會發行您的條件約束,但不檢查對應的資料。If set to False, your constraints are published without checking the corresponding data.
/p:/p: ScriptRefreshModule=(BOOLEAN 'True')ScriptRefreshModule=(BOOLEAN 'True') 在發行指令碼的結尾包含重新整理陳述式。Include refresh statements at the end of the publish script.
/p:/p: Storage=({File|Memory})Storage=({File|Memory}) 指定在建置資料庫模型時,如何儲存項目。Specifies how elements are stored when building the database model. 基於效能考量,預設值為 InMemory。For performance reasons the default is InMemory. 若為大型資料庫,則需要檔案型儲存體。For large databases, File backed storage is required.
/p:/p: TreatVerificationErrorsAsWarnings=(BOOLEAN)TreatVerificationErrorsAsWarnings=(BOOLEAN) 指定驗證是否發行期間發生的錯誤應該視為警告。Specifies whether errors encountered during publish verification should be treated as warnings. 系統會先針對產生的部署計畫執行檢查,再針對您的目標資料庫執行計畫。The check is performed against the generated deployment plan before the plan is executed against your target database. 計畫驗證會偵測出遺漏僅限於目標的物件 (如索引) 這類必須卸除後才能進行變更的問題。Plan verification detects problems such as the loss of target-only objects (such as indexes) that must be dropped to make a change. 驗證也會偵測因為參考複合專案而存在相依性 (如資料表或檢視),但卻不存在於目標資料庫中的情況。Verification will also detect situations where dependencies (such as a table or view) exist because of a reference to a composite project, but do not exist in the target database. 您可以選擇這樣做來取得所有的問題,而不是第一次發生錯誤時停止發行動作的完整清單。You might choose to do this to get a complete list of all issues, instead of having the publish action stop on the first error. /p:/p: UnmodifiableObjectWarnings=(BOOLEAN 'True')UnmodifiableObjectWarnings=(BOOLEAN 'True') 指定在無法修改的物件中發現差異時 (例如檔案的檔案大小或檔案路徑不同) 是否應該產生警告。Specifies whether warnings should be generated when differences are found in objects that cannot be modified, for example, if the file size or file paths were different for a file.
/p:/p: VerifyCollationCompatibility=(BOOLEAN 'True')VerifyCollationCompatibility=(BOOLEAN 'True') 指定是否驗證定序相容性。Specifies whether collation compatibility is verified.
/p:/p: VerifyDeployment=(BOOLEAN 'True')VerifyDeployment=(BOOLEAN 'True') 指定是否應該在發行前執行檢查,以便在出現阻止發行成功的問題時停止發行動作。Specifies whether checks should be performed before publishing that will stop the publish action if issues are present that might block successful publishing. 例如,如果目標資料庫的外部索引鍵不存在資料庫專案中,因而在您發行時造成錯誤,則發行動作可能會停止。For example, your publish action might stop if you have foreign keys on the target database that do not exist in the database project, and that causes errors when you publish.

SQLCMD 變數SQLCMD Variables

下表描述可用來覆寫在發行動作期間所用 SQL 命令 (sqlcmd) 變數值之選項的格式。The following table describes the format of the option that you can use to override the value of a SQL command (sqlcmd) variable used during a publish action. 命令列上指定的變數值會覆寫指派給變數的其他值 (例如在發行設定檔中)。The values of variable specified on the command line override other values assigned to the variable (for example, in a publish profile).

參數Parameter 預設Default DescriptionDescription
/Variables:{PropertyName}={Value}/Variables:{PropertyName}={Value} 指定動件特定變數的名稱/值對:{VariableName}={Value}。Specifies a name value pair for an action-specific variable; {VariableName}={Value}. DACPAC 檔案包含有效 SQLCMD 變數的清單。The DACPAC file contains the list of valid SQLCMD variables. 如果未針對每一個變數提供值,則會產生錯誤。An error results if a value is not provided for every variable.

匯出參數與屬性Export Parameters and Properties

SqlPackage.exe 的匯出動作會將即時資料庫從 SQL Server 或 Azure SQL Database 匯出到 BACPAC 套件 (.bacpac 檔案)。A SqlPackage.exe Export action exports a live database from SQL Server or Azure SQL Database to a BACPAC package (.bacpac file). 依預設,所有資料表的資料將包括在 .bacpac 檔案中。By default, data for all tables will be included in the .bacpac file. 您可以選擇性地只指定要匯出資料的資料表子集。Optionally, you can specify only a subset of tables for which to export data. 驗證 Export 動作,可確保 Azure SQL Database 相容於完整目標資料庫,即使已指定資料表子集進行匯出也一樣。Validation for the Export action ensures Azure SQL Database compatibility for the complete targeted database even if a subset of tables is specified for the export.

匯出動作的說明Help for Export action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a 匯出Export 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property;{PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/ SourceConnectionString:/SourceConnectionString: /scs/scs {string}{string} 指定來源資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the source database. 如果指定了此參數,就應該以獨佔方式將其用於所有其他來源參數。If this parameter is specified, it shall be used exclusively of all other source parameters.
/SourceDatabaseName:/SourceDatabaseName: /sdn/sdn {string}{string} 定義來源資料庫的名稱。Defines the name of the source database.
/SourceEncryptConnection:/SourceEncryptConnection: /sec/sec {True|False}{True|False} 指定 SQL 加密是否應該用於來源資料庫連接。Specifies if SQL encryption should be used for the source database connection.
/SourcePassword:/SourcePassword: /sp/sp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the source database.
/ SourceServerName:/SourceServerName: /ssn/ssn {string}{string} 定義裝載來源資料庫的伺服器名稱。Defines the name of the server hosting the source database.
/ SourceTimeout:/SourceTimeout: /st/st {int}{int} 指定建立來源資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the source database in seconds.
/SourceTrustServerCertificate:/SourceTrustServerCertificate: /stsc/stsc {True|False}{True|False} 指定是否要使用 SSL 來加密來源資料庫連線並且略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the source database connection and bypass walking the certificate chain to validate trust.
/SourceUser:/SourceUser: /su/su {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the source database.
/TargetFile:/TargetFile: /tf/tf {string}{string} 指定要做為目標的動作,而不是資料庫的目標檔案 (亦即.dacpac 檔案)。Specifies a target file (that is, a .dacpac file) to be used as the target of action instead of a database. 如果使用此參數,其他目標參數都應該無效。If this parameter is used, no other target parameter shall be valid. 此參數應僅支援資料庫目標的動作無效。This parameter shall be invalid for actions that only support database targets.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).

匯出動作特有的屬性Properties specific to the Export action

屬性Property ReplTest1Value DescriptionDescription
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: Storage=({File|Memory} 'File')Storage=({File|Memory} 'File') 指定支援儲存體的類型,以供結構描述模型在擷取期間使用。Specifies the type of backing storage for the schema model used during extraction.
/p:/p: TableData=(STRING)TableData=(STRING) 指出擷取資料的資料表。Indicates the table from which data will be extracted. 指定的資料表名稱,包含或不含方括號名稱部分,以下列格式: schema_name.table_identifier。Specify the table name with or without the brackets surrounding the name parts in the following format: schema_name.table_identifier.
/p:/p: TargetEngineVersion=({Default|Latest|V11|V12} 'Latest')TargetEngineVersion=({Default|Latest|V11|V12} 'Latest') 指定預期的目標引擎版本。Specifies what the target engine version is expected to be. 這會影響是否允許具有 V12 功能,例如記憶體最佳化的資料表,產生的 bacpac 中的 Azure SQL Database 伺服器所支援的物件。This affects whether to allow objects supported by Azure SQL Database servers with V12 capabilities, such as memory-optimized tables, in the generated bacpac.
/p:/p: VerifyFullTextDocumentTypesSupported=(BOOLEAN)VerifyFullTextDocumentTypesSupported=(BOOLEAN) 指定是否要驗證 Microsoft Azure SQL Database v12 支援的全文檢索文件類型。Specifies whether the supported full-text document types for MicrosoftAzure SQL Database v12 should be verified.

匯入參數與屬性Import Parameters and Properties

SqlPackage.exe 匯入動作匯入的結構描述和資料表的資料,從 BACPAC 套件-.bacpac 檔案-新的或空白的資料庫,在 SQL Server 或 Azure SQL Database。A SqlPackage.exe Import action imports the schema and table data from a BACPAC package - .bacpac file - into a new or empty database in SQL Server or Azure SQL Database. 在對現有資料庫進行匯入作業時,目標資料庫不能包含任何使用者定義的結構描述物件。At the time, of the import operation to an existing database, the target database cannot contain any user-defined schema objects.

命令動作的說明Help for command actions

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a 匯入Import 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property;{PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/Sourcefile:/SourceFile: /sf/sf {string}{string} 指定要當作動作來源使用的來源檔案。Specifies a source file to be used as the source of action. 如果使用了此參數,其他來源參數都應該無效。If this parameter is used, no other source parameter shall be valid.
/ TargetConnectionString:/TargetConnectionString: /tcs/tcs {string}{string} 指定目標資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the target database. 如果指定此參數,就應該以獨佔方式將它用於所有其他目標參數。If this parameter is specified, it shall be used exclusively of all other target parameters.
/TargetDatabaseName:/TargetDatabaseName: /tdn/tdn {string}{string} 指定 sqlpackage.exe 動作目標之資料庫名稱的覆寫。Specifies an override for the name of the database that is the target ofsqlpackage.exe Action.
/TargetEncryptConnection:/TargetEncryptConnection: /tec/tec {True|False}{True|False} 指定 SQL 加密是否應該用於目標資料庫連線。Specifies if SQL encryption should be used for the target database connection.
/ TargetPassword:/TargetPassword: /tp/tp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取目標資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the target database.
/ TargetServerName:/TargetServerName: /tsn/tsn {string}{string} 定義裝載目標資料庫的伺服器名稱。Defines the name of the server hosting the target database.
/TargetTimeout:/TargetTimeout: /tt/tt {int}{int} 指定建立目標資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the target database in seconds. Azure AD 中,建議您使用這個值是大於或等於為 30 秒。For Azure AD, it is recommended that this value be greater than or equal to 30 seconds.
/TargetTrustServerCertificate:/TargetTrustServerCertificate: /ttsc/ttsc {True|False}{True|False} 指定是否要使用 SSL 來加密目標資料庫連線並略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the target database connection and bypass walking the certificate chain to validate trust.
/ TargetUser:/TargetUser: /tu/tu {string}{string} 若為 SQL Server 驗證案例,則定義要用以存取目標資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).

匯入動作特有的屬性:Properties specific to the Import action:

屬性Property ReplTest1Value DescriptionDescription
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: DatabaseEdition=({Basic|Standard|Premium|Default} 'Default')DatabaseEdition=({Basic|Standard|Premium|Default} 'Default') 定義 Azure SQL Database 的版本。Defines the edition of an Azure SQL Database.
/p:/p: DatabaseMaximumSize=(INT32)DatabaseMaximumSize=(INT32) 定義 Azure SQL Database 的大小上限 (以 GB 表示)。Defines the maximum size in GB of an Azure SQL Database.
/p:/p: DatabaseServiceObjective=(STRING)DatabaseServiceObjective=(STRING) 定義 Azure SQL Database 的效能等級,例如 "P0" 或 "S1"。Defines the performance level of an Azure SQL Database such as"P0" or "S1".
/p:/p: ImportContributorArguments=(STRING)ImportContributorArguments=(STRING) 指定部署參與者的部署參與者引數。Specifies deployment contributor arguments for the deploymentcontributors. 這應該是以分號區隔的值清單。This should be a semi-colon delimited list of values.
/p:/p: ImportContributors=(STRING)ImportContributors=(STRING) 指定部署參與者,匯入 bacpac 時應該執行的。Specifies the deployment contributors, which should run when the bacpac is imported. 這應該是以分號區隔的完整組建參與者名稱或識別碼清單。This should be a semi-colon delimited list of fully qualified build contributor names or IDs.
/p:/p: Storage=({File|Memory})Storage=({File|Memory}) 指定在建置資料庫模型時,如何儲存項目。Specifies how elements are stored when building the database model. 基於效能考量,預設值為 InMemory。For performance reasons the default is InMemory. 若為大型資料庫,則需要檔案型儲存體。For large databases, File backed storage is required.

DeployReport 參數與屬性DeployReport Parameters and Properties

SqlPackage.exe 報表動作會建立發行動作所做變更的 XML 報表。A SqlPackage.exe report action creates an XML report of the changes that would be made by a publish action.

DeployReport 動作的說明Help for DeployReport action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a DeployReportDeployReport 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/OutputPath:/OutputPath: /op/op {string}{string} 指定輸出檔案產生位置的檔案路徑。Specifies the file path where the output files are generated.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Profile:/Profile: /pr/pr {string}{string} 指定 DAC 發行設定檔的檔案路徑。Specifies the file path to a DAC Publish Profile. 設定檔會定義產生輸出時要使用之屬性及變數的集合。The profile defines a collection of properties and variables to use when generating outputs.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property; {PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/ SourceConnectionString:/SourceConnectionString: /scs/scs {string}{string} 指定來源資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the source database. 如果指定了此參數,就應該以獨佔方式將其用於所有其他來源參數。If this parameter is specified, it shall be used exclusively of all other source parameters.
/SourceDatabaseName:/SourceDatabaseName: /sdn/sdn {string}{string} 定義來源資料庫的名稱。Defines the name of the source database.
/SourceEncryptConnection:/SourceEncryptConnection: /sec/sec {True|False}{True|False} 指定 SQL 加密是否應該用於來源資料庫連接。Specifies if SQL encryption should be used for the source database connection.
/Sourcefile:/SourceFile: /sf/sf {string}{string} 指定要當作動作來源使用的來源檔案,而非資料庫。Specifies a source file to be used as the source of action instead of a database. 如果使用了此參數,其他來源參數都應該無效。If this parameter is used, no other source parameter shall be valid.
/SourcePassword:/SourcePassword: /sp/sp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the source database.
/ SourceServerName:/SourceServerName: /ssn/ssn {string}{string} 定義裝載來源資料庫的伺服器名稱。Defines the name of the server hosting the source database.
/ SourceTimeout:/SourceTimeout: /st/st {int}{int} 指定建立來源資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the source database in seconds.
/SourceTrustServerCertificate:/SourceTrustServerCertificate: /stsc/stsc {True|False}{True|False} 指定是否要使用 SSL 來加密來源資料庫連線並且略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the source database connection and bypass walking the certificate chain to validate trust.
/SourceUser:/SourceUser: /su/su {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the source database.
/ TargetConnectionString:/TargetConnectionString: /tcs/tcs {string}{string} 指定目標資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the target database. 如果指定此參數,就應該以獨佔方式將它用於所有其他目標參數。If this parameter is specified, it shall be used exclusively of all other target parameters.
/TargetDatabaseName:/TargetDatabaseName: /tdn/tdn {string}{string} 指定 sqlpackage.exe 動作目標之資料庫名稱的覆寫。Specifies an override for the name of the database that is the target of sqlpackage.exe Action.
/TargetEncryptConnection:/TargetEncryptConnection: /tec/tec {True|False}{True|False} 指定 SQL 加密是否應該用於目標資料庫連線。Specifies if SQL encryption should be used for the target database connection.
/TargetFile:/TargetFile: /tf/tf {string}{string} 指定要做為目標的動作,而不是資料庫的目標檔案 (亦即.dacpac 檔案)。Specifies a target file (that is, a .dacpac file) to be used as the target of action instead of a database. 如果使用此參數,其他目標參數都應該無效。If this parameter is used, no other target parameter shall be valid. 此參數應僅支援資料庫目標的動作無效。This parameter shall be invalid for actions that only support database targets.
/ TargetPassword:/TargetPassword: /tp/tp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取目標資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the target database.
/ TargetServerName:/TargetServerName: /tsn/tsn {string}{string} 定義裝載目標資料庫的伺服器名稱。Defines the name of the server hosting the target database.
/TargetTimeout:/TargetTimeout: /tt/tt {int}{int} 指定建立目標資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the target database in seconds. Azure AD 中,建議您使用這個值是大於或等於為 30 秒。For Azure AD, it is recommended that this value be greater than or equal to 30 seconds.
/TargetTrustServerCertificate:/TargetTrustServerCertificate: /ttsc/ttsc {True|False}{True|False} 指定是否要使用 SSL 來加密目標資料庫連線並略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the target database connection and bypass walking the certificate chain to validate trust.
/ TargetUser:/TargetUser: /tu/tu {string}{string} 若為 SQL Server 驗證案例,則定義要用以存取目標資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/Variables:/Variables: /v/v {PropertyName}={Value}{PropertyName}={Value} 指定動件特定變數的名稱/值對:{VariableName}={Value}。Specifies a name value pair for an action-specific variable; {VariableName}={Value}. DACPAC 檔案包含有效 SQLCMD 變數的清單。The DACPAC file contains the list of valid SQLCMD variables. 如果未針對每一個變數提供值,則會產生錯誤。An error results if a value is not provided for every variable.

DeployReport 動作特有的屬性Properties specific to the DeployReport action

屬性Property ReplTest1Value DescriptionDescription
/p:/p: AdditionalDeploymentContributorArguments=(STRING)AdditionalDeploymentContributorArguments=(STRING) 為部署參與者指定其他部署參與者引數。Specifies additional deployment contributor arguments for the deployment contributors. 這應該是以分號區隔的值清單。This should be a semi-colon delimited list of values.
/p:/p: AdditionalDeploymentContributors=(STRING)AdditionalDeploymentContributors=(STRING) 指定部署 dacpac 時應該執行的其他部署參與者。Specifies additional deployment contributors, which should run when the dacpac is deployed. 這應該是以分號區隔的完整組建參與者名稱或識別碼清單。This should be a semi-colon delimited list of fully qualified build contributor names or IDs.
/p:/p: AllowDropBlocking Assemblies=(BOOLEAN)AllowDropBlocking Assemblies=(BOOLEAN) 這個屬性是供 SqlClr 部署用來使任何封鎖的組件會在部署計畫中卸除。This property is used by SqlClr deployment to cause any blocking assemblies to be dropped as part of the deployment plan. 根據預設,如果必須卸除任何參考組件,則該封鎖/參考組件會封鎖組件更新。By default, any blocking/referencing assemblies will block an assembly update if the referencing assembly needs to be dropped.
/p:/p: AllowIncompatiblePlatform=(BOOLEAN)AllowIncompatiblePlatform=(BOOLEAN) 指定儘管 SQL Server 平台不相容,是否仍要嘗試動作。Specifies whether to attempt the action despite incompatible SQL Server platforms.
/p:/p: AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN)AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN) 若此屬性設定為 true,請勿封鎖具有資料列層級安全性之資料表的資料動作。Do not block data motion on a table that has Row Level Security if this property is set to true. 預設值為 false。Default is false.
/p:/p: BackupDatabaseBeforeChanges=(BOOLEAN)BackupDatabaseBeforeChanges=(BOOLEAN) 在部署任何變更之前,先備份資料庫。Backups the database before deploying any changes.
/p:/p: BlockOnPossibleDataLoss=(BOOLEAN 'True')BlockOnPossibleDataLoss=(BOOLEAN 'True') 指定如果發行作業可能導致資料遺失,就應該終止發行事件。Specifies that the publish episode should be terminated if there is a possibility of data loss resulting from the publish.operation.
/p:/p: BlockWhenDriftDetected=(BOOLEAN 'True')BlockWhenDriftDetected=(BOOLEAN 'True') 指定是否封鎖更新結構描述不再符合註冊或已取消註冊的資料庫。Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: CommentOutSetVarDeclarations=(BOOLEAN)CommentOutSetVarDeclarations=(BOOLEAN) 指定在產生的發行指令碼中是否應該將 SETVAR 變數的宣告標記為註解。Specifies whether the declaration of SETVAR variables should be commented out in the generated publish script. 如果您計畫在使用 SQLCMD.EXE 等工具進行發行時在命令列指定值,就可以選擇這種作法。You might choose to do this if you plan to specify the values on the command line when you publish by using a tool such as SQLCMD.EXE.
/p:/p: CompareUsingTargetCollation=(BOOLEAN)CompareUsingTargetCollation=(BOOLEAN) 這個設定表示資料庫的定序於部署期間的處理方式。如果目標資料庫的定序不符合來源所指定的定序,預設會更新目標資料庫的定序。This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. 當設定這個選項時,則應該使用目標資料庫 (或伺服器) 的定序。When this option is set, the target database's (or server's) collation should be used.
/p:/p: CreateNewDatabase=(BOOLEAN)CreateNewDatabase=(BOOLEAN) 指定當您發行至資料庫時,應該更新目標資料庫或應該卸除並重新建立目標資料庫。Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.
/p:/p: DatabaseEdition=({Basic|Standard|Premium|Default} 'Default')DatabaseEdition=({Basic|Standard|Premium|Default} 'Default') 定義 Azure SQL Database 的版本。Defines the edition of an Azure SQL Database.
/p:/p: DatabaseMaximumSize=(INT32)DatabaseMaximumSize=(INT32) 定義 Azure SQL Database 的大小上限 (以 GB 表示)。Defines the maximum size in GB of an Azure SQL Database.
/p:/p: DatabaseServiceObjective=(STRING)DatabaseServiceObjective=(STRING) 定義 Azure SQL Database 的效能等級,例如 "P0" 或 "S1"。Defines the performance level of an Azure SQL Database such as "P0" or "S1".
/p:/p: DeployDatabaseInSingleUserMode=(BOOLEAN)DeployDatabaseInSingleUserMode=(BOOLEAN) 若為 true,則資料庫會在設定為單一使用者模式後部署。if true, the database is set to Single User Mode before deploying.
/p:/p: DisableAndReenableDdlTriggers=(BOOLEAN 'True')DisableAndReenableDdlTriggers=(BOOLEAN 'True') 指定是否在發行程序開始時停用資料定義語言 (DDL) 觸發程序,並在發行動作結束時重新啟用。Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.
/p:/p: DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True')DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True') 如果為 true,則不會改變異動資料擷取物件。If true, Change Data Capture objects are not altered.
/p:/p: DoNotAlterReplicatedObjects=(BOOLEAN 'True')DoNotAlterReplicatedObjects=(BOOLEAN 'True') 指定驗證期間是否識別有複寫的物件。Specifies whether objects that are replicated are identified during verification.
/p:/p: DoNotDropObjectType=(STRING)DoNotDropObjectType=(STRING) 物件型別,不應該捨棄當 DropObjectsNotInSource 為 true。An object type that should not be dropped when DropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DoNotDropObjectTypes=(STRING)DoNotDropObjectTypes=(STRING) 當 DropObjectsNotInSource 為 true 時不應捨棄的分號分隔物件類型清單。A semicolon-delimited list of object types that should not be dropped when DropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DropConstraintsNotInSource=(BOOLEAN 'True')DropConstraintsNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的條件約束。Specifies whether constraints that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropDmlTriggersNotInSource=(BOOLEAN 'True')DropDmlTriggersNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的 DML 觸發程序。Specifies whether DML triggers that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropExtendedPropertiesNotInSource=(BOOLEAN 'True')DropExtendedPropertiesNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的擴充屬性。Specifies whether extended properties that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropIndexesNotInSource=(BOOLEAN 'True')DropIndexesNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的索引。Specifies whether indexes that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropObjectsNotInSource=(BOOLEAN)DropObjectsNotInSource=(BOOLEAN) 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的物件。Specifies whether objects that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database. 此值的優先順序高過 DropExtendedProperties。This value takes precedence over DropExtendedProperties.
/p:/p: DropPermissionsNotInSource=(BOOLEAN)DropPermissionsNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的權限。Specifies whether permissions that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropRoleMembersNotInSource=(BOOLEAN)DropRoleMembersNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除資料庫快照集 (.dacpac) 檔案中沒有定義的角色成員。Specifies whether role members that are not defined in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropStatisticsNotInSource=(BOOLEAN 'True')DropStatisticsNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫卸除不存在於資料庫快照集 (.dacpac) 檔案中的統計資料。Specifies whether statistics that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: ExcludeObjectType=(STRING)ExcludeObjectType=(STRING) 部署期間應該忽略的物件類型。An object type that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: ExcludeObjectTypes=(STRING)ExcludeObjectTypes=(STRING) 以分號區隔的物件類型清單,列出部署期間應該忽略的物件類型。A semicolon-delimited list of object types that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: GenerateSmartDefaults=(BOOLEAN)GenerateSmartDefaults=(BOOLEAN) 在更新含有資料且資料行不允許 null 值的資料表時,自動提供預設值。Automatically provides a default value when updating a table that contains data with a column that does not allow null values.
/p:/p: IgnoreAnsiNulls=(BOOLEAN 'True')IgnoreAnsiNulls=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 ANSI NULLS 設定的差異。Specifies whether differences in the ANSI NULLS setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreAuthorizer=(BOOLEAN)IgnoreAuthorizer=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新授權者的差異。Specifies whether differences in the Authorizer should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnCollation=(BOOLEAN)IgnoreColumnCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料行定序的差異。Specifies whether differences in the column collations should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnOrder=(BOOLEAN)IgnoreColumnOrder=(BOOLEAN) 指定當您發行至資料庫時,是否應略過或更新資料表資料行順序的差異。Specifies whether differences in table column order should be ignored or updated when you publish to a database.
/p:/p: IgnoreComments=(BOOLEAN)IgnoreComments=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新註解的差異。Specifies whether differences in the comments should be ignored or updated when you publish to a database.
/p:/p: IgnoreCryptographicProviderFilePath=(BOOLEAN 'True')IgnoreCryptographicProviderFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新密碼編譯提供者之檔案路徑的差異。Specifies whether differences in the file path for the cryptographic provider should be ignored or updated when you publish to a database.
/p:/p: IgnoreDdlTriggerOrder=(BOOLEAN)IgnoreDdlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫或伺服器時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序的順序差異。Specifies whether differences in the order of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database or server.
/p:/p: IgnoreDdlTriggerState=(BOOLEAN)IgnoreDdlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDefaultSchema=(BOOLEAN)IgnoreDefaultSchema=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新預設結構描述的差異。Specifies whether differences in the default schema should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerOrder=(BOOLEAN)IgnoreDmlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料操作語言 (DML) 觸發程序的順序差異。Specifies whether differences in the order of Data Manipulation Language (DML) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerState=(BOOLEAN)IgnoreDmlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新 DML 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of DML triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreExtendedProperties=(BOOLEAN)IgnoreExtendedProperties=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新擴充屬性的差異。Specifies whether differences in the extended properties should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileAndLogFilePath=(BOOLEAN 'True')IgnoreFileAndLogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新檔案和記錄檔之路徑的差異。Specifies whether differences in the paths for files and log files should be ignored or updated when you publish to a database.
/p:/p: IgnoreFilegroupPlacement=(BOOLEAN 'True')IgnoreFilegroupPlacement=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 FILEGROUP 中物件位置的差異。Specifies whether differences in the placement of objects in FILEGROUPs should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileSize=(BOOLEAN 'True')IgnoreFileSize=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略檔案大小的差異或應該發出警告。Specifies whether differences in the file sizes should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreFillFactor=(BOOLEAN 'True')IgnoreFillFactor=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略索引儲存體之填滿因數的差異或應該發出警告Specifies whether differences in the fill factor for index storage should be ignored or whether a warning should be issued when you publish to a database
/p:/p: IgnoreFullTextCatalogFilePath=(BOOLEAN 'True')IgnoreFullTextCatalogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略全文檢索目錄之檔案路徑的差異或應該發出警告。Specifies whether differences in the file path for the full-text catalog should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreIdentitySeed=(BOOLEAN)IgnoreIdentitySeed=(BOOLEAN) 指定當您發行更新至資料庫時,應該忽略或更新識別欄位之種子的差異。Specifies whether differences in the seed for an identity column should be ignored or updated when you publish updates to a database.
/p:/p: IgnoreIncrement=(BOOLEAN)IgnoreIncrement=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新識別欄位之增量的差異。Specifies whether differences in the increment for an identity column should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexOptions=(BOOLEAN)IgnoreIndexOptions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引選項的差異。Specifies whether differences in the index options should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexPadding=(BOOLEAN 'True')IgnoreIndexPadding=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新索引填補的差異。Specifies whether differences in the index padding should be ignored or updated when you publish to a database.
/p:/p: IgnoreKeywordCasing=(BOOLEAN 'True')IgnoreKeywordCasing=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新關鍵字之大小寫的差異。Specifies whether differences in the casing of keywords should be ignored or updated when you publish to a database.
/p:/p: IgnoreLockHintsOnIndexes=(BOOLEAN)IgnoreLockHintsOnIndexes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引之鎖定提示的差異。Specifies whether differences in the lock hints on indexes should be ignored or updated when you publish to a database.
/p:/p: IgnoreLoginSids=(BOOLEAN 'True')IgnoreLoginSids=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新安全性識別碼 (SID) 的差異。Specifies whether differences in the security identification number (SID) should be ignored or updated when you publish to a database.
/p:/p: IgnoreNotForReplication=(BOOLEAN)IgnoreNotForReplication=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新不可複寫設定。Specifies whether the not for replication settings should be ignored or updated when you publish to a database.
/p:/p: IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True')IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新物件在資料分割配置上的位置。Specifies whether an object's placement on a partition scheme should be ignored or updated when you publish to a database.
/p:/p: IgnorePartitionSchemes=(BOOLEAN)IgnorePartitionSchemes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料分割配置和函式的差異。Specifies whether differences in partition schemes and functions should be ignored or updated when you publish to a database.
/p:/p: IgnorePermissions=(BOOLEAN)IgnorePermissions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新權限的差異。Specifies whether differences in the permissions should be ignored or updated when you publish to a database.
/p:/p: IgnoreQuotedIdentifiers=(BOOLEAN 'True')IgnoreQuotedIdentifiers=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新引號識別項設定的差異。Specifies whether differences in the quoted identifiers setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreRoleMembership=(BOOLEAN)IgnoreRoleMembership=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新登入之角色成員資格的差異。Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.
/p:/p: IgnoreRouteLifetime=(BOOLEAN 'True')IgnoreRouteLifetime=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 SQL Server 將路由保留在路由表中之時間長短的差異Specifies whether differences in the amount of time that SQL Server retains the route in the routing table should be ignored or updated when you publish to a database
/p:/p: IgnoreSemicolonBetweenStatements=(BOOLEAN 'True')IgnoreSemicolonBetweenStatements=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 T-SQL 陳述式間之分號的差異。Specifies whether differences in the semi-colons between T-SQL statements will be ignored or updated when you publish to a database.
/p:/p: IgnoreTableOptions=(BOOLEAN)IgnoreTableOptions=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新資料表選項的差異。Specifies whether differences in the table options will be ignored or updated when you publish to a database.
/p:/p: IgnoreUserSettingsObjects=(BOOLEAN)IgnoreUserSettingsObjects=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新使用者設定物件的差異。Specifies whether differences in the user settings objects will be ignored or updated when you publish to a database.
/p:/p: IgnoreWhitespace=(BOOLEAN 'True')IgnoreWhitespace=(BOOLEAN 'True') 指定當您發行至資料庫時,將忽略或更新空白字元的差異。Specifies whether differences in white space will be ignored or updated when you publish to a database.
/p:/p: IgnoreWithNocheckOnCheckConstraints=(BOOLEAN)IgnoreWithNocheckOnCheckConstraints=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新檢查條件約束之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for check constraints will be ignored or updated when you publish to a database.
/p:/p: IgnoreWithNocheckOnForeignKeys=(BOOLEAN)IgnoreWithNocheckOnForeignKeys=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新外部索引鍵之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for foreign keys will be ignored or updated when you publish to a database.
/p:/p: IncludeCompositeObjects=(BOOLEAN)IncludeCompositeObjects=(BOOLEAN) 將所有複合項目包含在單一發行作業中。Include all composite elements as part of a single publish operation.
/p:/p: IncludeTransactionalScripts=(BOOLEAN)IncludeTransactionalScripts=(BOOLEAN) 指定當您發行至資料庫時,是否應該盡可能使用交易陳述式。Specifies whether transactional statements should be used where possible when you publish to a database.
/p:/p: NoAlterStatementsToChangeClrTypes=(BOOLEAN)NoAlterStatementsToChangeClrTypes=(BOOLEAN) 指定發行在發現差異時一定要卸除並重新建立組件,而不是發出 ALTER ASSEMBLY 陳述式。Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.
/p:/p: PopulateFilesOnFileGroups=(BOOLEAN 'True')PopulateFilesOnFileGroups=(BOOLEAN 'True') 指定在目標資料庫中建立新 FileGroup 時,是否一併建立新檔案。Specifies whether a new file is also created when a new FileGroup is created in the target database.
/p:/p: RegisterDataTierApplication=(BOOLEAN)RegisterDataTierApplication=(BOOLEAN) 指定結構描述是否向資料庫伺服器註冊。Specifies whether the schema is registered with the database server.
/p:/p: RunDeploymentPlanExecutors=(BOOLEAN)RunDeploymentPlanExecutors=(BOOLEAN) 指定執行其他作業時,是否應該執行 DeploymentPlanExecutor 參與者。Specifies whether DeploymentPlanExecutor contributors should be run when other operations are executed.
/p:/p: ScriptDatabaseCollation=(BOOLEAN)ScriptDatabaseCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫定序的差異。Specifies whether differences in the database collation should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseCompatibility=(BOOLEAN)ScriptDatabaseCompatibility=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫相容性的差異。Specifies whether differences in the database compatibility should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseOptions=(BOOLEAN 'True')ScriptDatabaseOptions=(BOOLEAN 'True') 指定是否應該在發行動作中設定或更新目標資料庫屬性。Specifies whether target database properties should be set or updated as part of the publish action.
/p:/p: ScriptDeployStateChecks=(BOOLEAN)ScriptDeployStateChecks=(BOOLEAN) 指定是否在發行指令碼中產生陳述式,來驗證資料庫名稱和伺服器名稱是否符合資料庫專案中指定的名稱。Specifies whether statements are generated in the publish script to verify that the database name and server name match the names specified in the database project.
/p:/p: ScriptFileSize=(BOOLEAN)ScriptFileSize=(BOOLEAN) 控制將檔案加入至檔案群組時是否指定大小。Controls whether size is specified when adding a file to a filegroup.
/p:/p: ScriptNewConstraintValidation=(BOOLEAN 'True')ScriptNewConstraintValidation=(BOOLEAN 'True') 在發行結束時,所有會驗證條件約束當做單一集合,避免檢查或外部索引鍵條件約束在發行所造成的資料錯誤。At the end of publish all of the constraints will be verified as one set, avoiding data errors caused by a check or foreign key constraint in the middle of publish. 如果設為 False,則會發行您的條件約束,但不檢查對應的資料。If set to False, your constraints are published without checking the corresponding data.
/p:/p: ScriptRefreshModule=(BOOLEAN 'True')ScriptRefreshModule=(BOOLEAN 'True') 在發行指令碼的結尾包含重新整理陳述式。Include refresh statements at the end of the publish script.
/p:/p: Storage=({File|Memory})Storage=({File|Memory}) 指定在建置資料庫模型時,如何儲存項目。Specifies how elements are stored when building the database model. 基於效能考量,預設值為 InMemory。For performance reasons the default is InMemory. 若為大型資料庫,則需要檔案型儲存體。For large databases, File backed storage is required.
/p:/p: TreatVerificationErrorsAsWarnings=(BOOLEAN)TreatVerificationErrorsAsWarnings=(BOOLEAN) 指定驗證是否發行期間發生的錯誤應該視為警告。Specifies whether errors encountered during publish verification should be treated as warnings. 系統會先針對產生的部署計畫執行檢查,再針對您的目標資料庫執行計畫。The check is performed against the generated deployment plan before the plan is executed against your target database. 計畫驗證會偵測出遺漏僅限於目標的物件 (如索引) 這類必須卸除後才能進行變更的問題。Plan verification detects problems such as the loss of target-only objects (such as indexes) that must be dropped to make a change. 驗證也會偵測因為參考複合專案而存在相依性 (如資料表或檢視),但卻不存在於目標資料庫中的情況。Verification will also detect situations where dependencies (such as a table or view) exist because of a reference to a composite project, but do not exist in the target database. 您可以選擇這樣做來取得所有的問題,而不是第一次發生錯誤時停止發行動作的完整清單。You might choose to do this to get a complete list of all issues, instead of having the publish action stop on the first error.
/p:/p: UnmodifiableObjectWarnings=(BOOLEAN 'True')UnmodifiableObjectWarnings=(BOOLEAN 'True') 指定在無法修改的物件中發現差異時 (例如檔案的檔案大小或檔案路徑不同) 是否應該產生警告。Specifies whether warnings should be generated when differences are found in objects that cannot be modified, for example, if the file size or file paths were different for a file.
/p:/p: VerifyCollationCompatibility=(BOOLEAN 'True')VerifyCollationCompatibility=(BOOLEAN 'True') 指定是否驗證定序相容性。Specifies whether collation compatibility is verified.
/p:/p: VerifyDeployment=(BOOLEAN 'True')VerifyDeployment=(BOOLEAN 'True') 指定是否應該在發行前執行檢查,以便在出現阻止發行成功的問題時停止發行動作。Specifies whether checks should be performed before publishing that will stop the publish action if issues are present that might block successful publishing. 例如,如果目標資料庫的外部索引鍵不存在資料庫專案中,因而在您發行時造成錯誤,則發行動作可能會停止。For example, your publish action might stop if you have foreign keys on the target database that do not exist in the database project, and that causes errors when you publish.

DriftReport 參數DriftReport Parameters

SqlPackage.exe 報表動作會建立自從上次註冊以來已經對註冊資料庫所做變更的 XML 報表。A SqlPackage.exe report action creates an XML report of the changes that have been made to the registered database since it was last registered.

DriftReport 動作的說明Help for DriftReport action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a DriftReportDriftReport 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/OutputPath:/OutputPath: /op/op {string}{string} 指定輸出檔案產生位置的檔案路徑。Specifies the file path where the output files are generated.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/ TargetConnectionString:/TargetConnectionString: /tcs/tcs {string}{string} 指定目標資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the target database. 如果指定此參數,就應該以獨佔方式將它用於所有其他目標參數。If this parameter is specified, it shall be used exclusively of all other target parameters.
/TargetDatabaseName:/TargetDatabaseName: /tdn/tdn {string}{string} 指定 sqlpackage.exe 動作目標之資料庫名稱的覆寫。Specifies an override for the name of the database that is the target ofsqlpackage.exe Action.
/TargetEncryptConnection:/TargetEncryptConnection: /tec/tec {True|False}{True|False} 指定 SQL 加密是否應該用於目標資料庫連線。Specifies if SQL encryption should be used for the target database connection.
/ TargetPassword:/TargetPassword: /tp/tp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取目標資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the target database.
/ TargetServerName:/TargetServerName: /tsn/tsn {string}{string} 定義裝載目標資料庫的伺服器名稱。Defines the name of the server hosting the target database.
/TargetTimeout:/TargetTimeout: /tt/tt {int}{int} 指定建立目標資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the target database in seconds. Azure AD 中,建議您使用這個值是大於或等於為 30 秒。For Azure AD, it is recommended that this value be greater than or equal to 30 seconds.
/TargetTrustServerCertificate:/TargetTrustServerCertificate: /ttsc/ttsc {True|False}{True|False} 指定是否要使用 SSL 來加密目標資料庫連線並略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the target database connection and bypass walking the certificate chain to validate trust.
/ TargetUser:/TargetUser: /tu/tu {string}{string} 若為 SQL Server 驗證案例,則定義要用以存取目標資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).

指令碼參數與屬性Script Parameters and Properties

SqlPackage.exe 指令碼動作建立的 Transact-SQL 累加更新指令碼會更新目標資料庫的結構描述,使其符合來源資料庫的結構描述。A SqlPackage.exe script action creates a Transact-SQL incremental update script that updates the schema of a target database to match the schema of a source database.

指令碼動作的說明Help for the Script action

參數Parameter 簡短形式Short Form ReplTest1Value DescriptionDescription
/Action:/Action: /a/a 指令碼Script 指定要執行的動作。Specifies the action to be performed.
/AccessToken:/AccessToken: /at/at {string}{string} 根據要在連線到目標資料庫時使用的驗證存取權杖,來指定權杖。Specifies the token based authentication access token to use when connect to the target database.
/DeployScriptPath:/DeployScriptPath: /dsp/dsp {string}{string} 指定選擇性檔案路徑來輸出部署指令碼。Specifies an optional file path to output the deployment script. 對於 Azure 部署,若有 TSQL 命令要建立或修改 master 資料庫,將會對指令碼寫入相同的路徑,但會使用 "Filename_Master.sql" 做為輸出檔案名稱。For Azure deployments, if there are TSQL commands to create or modify the master database, a script will be written to the same path but with "Filename_Master.sql" as the output file name.
/DeployReportPath:/DeployReportPath: /drp/drp {string}{string} 指定選擇性檔案路徑來輸出部署報表 XML 檔案。Specifies an optional file path to output the deployment report xml file.
/Diagnostics:/Diagnostics: /d/d {True|False}{True|False} 指定診斷記錄是否輸出到主控台。Specifies whether diagnostic logging is output to the console. 預設為 False。Defaults to False.
/ DiagnosticsFile:/DiagnosticsFile: /df/df {string}{string} 指定要儲存診斷記錄的檔案。Specifies a file to store diagnostic logs.
/MaxParallelism:/MaxParallelism: /mp/mp {int}{int} 指定針對資料庫執行之並行作業的平行處理原則的程度。Specifies the degree of parallelism for concurrent operations running against a database. 預設值為 8。The default value is 8.
/OutputPath:/OutputPath: /op/op {string}{string} 指定輸出檔案產生位置的檔案路徑。Specifies the file path where the output files are generated.
/ OverwriteFiles:/OverwriteFiles: /of/of {True|False}{True|False} 指定 sqlpackage.exe 是否應該覆寫現有的檔案。Specifies if sqlpackage.exe should overwrite existing files. 指定 false 會導致 sqlpackage.exe 在遇到現有的檔案時中止動作。Specifying false causes sqlpackage.exe to abort action if an existing file is encountered. 預設值是 True。Default value is True.
/Profile:/Profile: /pr/pr {string}{string} 指定 DAC 發行設定檔的檔案路徑。Specifies the file path to a DAC Publish Profile. 設定檔會定義產生輸出時要使用之屬性及變數的集合。The profile defines a collection of properties and variables to use when generating outputs.
/Properties:/Properties: /p/p {PropertyName}={Value}{PropertyName}={Value} 指定動件特定屬性的名稱/值對:{PropertyName}={Value}。Specifies a name value pair for an action-specific property;{PropertyName}={Value}. 請參閱特定動作的說明,以便查看該動作的屬性名稱。Refer to the help for a specific action to see that action's property names. 範例: sqlpackage.exe /Action: 發行 /?。Example: sqlpackage.exe /Action:Publish /?.
/Quiet:/Quiet: /q/q {True|False}{True|False} 指定是否隱藏詳細的意見反應。Specifies whether detailed feedback is suppressed. 預設為 False。Defaults to False.
/ SourceConnectionString:/SourceConnectionString: /scs/scs {string}{string} 指定來源資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the source database. 如果指定了此參數,就應該以獨佔方式將其用於所有其他來源參數。If this parameter is specified, it shall be used exclusively of all other source parameters.
/SourceDatabaseName:/SourceDatabaseName: /sdn/sdn {string}{string} 定義來源資料庫的名稱。Defines the name of the source database.
/SourceEncryptConnection:/SourceEncryptConnection: /sec/sec {True|False}{True|False} 指定 SQL 加密是否應該用於來源資料庫連接。Specifies if SQL encryption should be used for the source database connection.
/Sourcefile:/SourceFile: /sf/sf {string}{string} 指定要當作動作來源使用的來源檔案。Specifies a source file to be used as the source of action. 如果使用了此參數,其他來源參數都應該無效。If this parameter is used, no other source parameter shall be valid.
/SourcePassword:/SourcePassword: /sp/sp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the source database.
/ SourceServerName:/SourceServerName: /ssn/ssn {string}{string} 定義裝載來源資料庫的伺服器名稱。Defines the name of the server hosting the source database.
/ SourceTimeout:/SourceTimeout: /st/st {int}{int} 指定建立來源資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the source database in seconds.
/SourceTrustServerCertificate:/SourceTrustServerCertificate: /stsc/stsc {True|False}{True|False} 指定是否要使用 SSL 來加密來源資料庫連線並且略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the source database connection and bypass walking the certificate chain to validate trust.
/SourceUser:/SourceUser: /su/su {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取來源資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the source database.
/ TargetConnectionString:/TargetConnectionString: /tcs/tcs {string}{string} 指定目標資料庫的有效 SQL Server/Azure 連接字串。Specifies a valid SQL Server/Azure connection string to the target database. 如果指定此參數,就應該以獨佔方式將它用於所有其他目標參數。If this parameter is specified, it shall be used exclusively ofall other target parameters.
/TargetDatabaseName:/TargetDatabaseName: /tdn/tdn {string}{string} 指定 sqlpackage.exe 動作目標之資料庫名稱的覆寫。Specifies an override for the name of the database that is the target of sqlpackage.exe Action.
/TargetEncryptConnection:/TargetEncryptConnection: /tec/tec {True|False}{True|False} 指定 SQL 加密是否應該用於目標資料庫連線。Specifies if SQL encryption should be used for the target database connection.
/TargetFile:/TargetFile: /tf/tf {string}{string} 指定要做為目標的動作,而不是資料庫的目標檔案 (亦即.dacpac 檔案)。Specifies a target file (that is, a .dacpac file) to be used as the target of action instead of a database. 如果使用此參數,其他目標參數都應該無效。If this parameter is used, no other target parameter shall be valid. 此參數應僅支援資料庫目標的動作無效。This parameter shall be invalid for actions that only support database targets.
/ TargetPassword:/TargetPassword: /tp/tp {string}{string} 若為 SQL Server 驗證案例,則定義要用來存取目標資料庫的密碼。For SQL Server Auth scenarios, defines the password to use to access the target database.
/ TargetServerName:/TargetServerName: /tsn/tsn {string}{string} 定義裝載目標資料庫的伺服器名稱。Defines the name of the server hosting the target database.
/TargetTimeout:/TargetTimeout: /tt/tt {int}{int} 指定建立目標資料庫連線的逾時 (以秒為單位)。Specifies the timeout for establishing a connection to the target database in seconds. Azure AD 中,建議您使用這個值是大於或等於為 30 秒。For Azure AD, it is recommended that this value be greater than or equal to 30 seconds.
/TargetTrustServerCertificate:/TargetTrustServerCertificate: /ttsc/ttsc {True|False}{True|False} 指定是否要使用 SSL 來加密目標資料庫連線並略過驗證信任的憑證鏈結。Specifies whether to use SSL to encrypt the target database connection and bypass walking the certificate chain to validate trust.
/ TargetUser:/TargetUser: /tu/tu {string}{string} 若為 SQL Server 驗證案例,則定義要用以存取目標資料庫的 SQL Server 使用者。For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.
/TenantId:/TenantId: /tid/tid {string}{string} 代表 Azure AD 租用戶識別碼或網域名稱。Represents the Azure AD tenant ID or domain name. 此選項,才可支援客體,或匯入 Azure AD 使用者,以及 Microsoft 帳戶,例如 outlook.com、 hotmail.com 或 live.com。This option is required to support guest or imported Azure AD users as well as Microsoft accounts such as outlook.com, hotmail.com, or live.com. 如果省略這個參數,則 Azure AD 的預設租用戶識別碼將用於,假設已驗證的使用者是此廣告的原生的使用者。If this parameter is omitted, the default tenant ID for Azure AD will be used, assuming that the authenticated user is a native user for this AD. 不過,在此情況下任何來賓或匯入的使用者和/或裝載於此 Azure AD 中的 Microsoft 帳戶不支援,而且作業會失敗。However, in this case any guest or imported users and/or Microsoft accounts hosted in this Azure AD are not supported and the operation will fail.
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/ UniversalAuthentication:/UniversalAuthentication: /ua/ua {True|False}{True|False} 指定是否應使用通用驗證。Specifies if Universal Authentication should be used. 設為 True 時,互動式驗證通訊協定已啟用支援 MFA。When set to True, the interactive authentication protocol is activated supporting MFA. 此選項也可以用於 Azure AD 驗證,而不需要 MFA,使用互動式的通訊協定,需要使用者輸入其使用者名稱和密碼或整合式的驗證 (Windows 認證)。This option can also be used for Azure AD authentication without MFA, using an interactive protocol requiring the user to enter their username and password or integrated authentication (Windows credentials). SourceConnectionString 時 /UniversalAuthentication 設為 True 時,可以指定任何 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to True, no Azure AD authentication can be specified in SourceConnectionString (/scs). SourceConnectionString 當 /UniversalAuthentication 設定為 False 時,必須指定 Azure AD 驗證 (/ scs)。When /UniversalAuthentication is set to False, Azure AD authentication must be specified in SourceConnectionString (/scs).
如需有關 Active Directory 通用驗證的詳細資訊,請參閱 < SQL Database 和 SQL 資料倉儲 (mfa 的 SSMS 支援) 的通用驗證For more information about Active Directory Universal Authentication, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA).
/Variables:/Variables: /v/v {PropertyName}={Value}{PropertyName}={Value} 指定動件特定變數的名稱/值對:{VariableName}={Value}。Specifies a name value pair for an action-specific variable;{VariableName}={Value}. DACPAC 檔案包含有效 SQLCMD 變數的清單。The DACPAC file contains the list of valid SQLCMD variables. 如果未針對每一個變數提供值,則會產生錯誤。An error results if a value is not provided for every variable.

指令碼動作特有的屬性Properties specific to the Script action

屬性Property ReplTest1Value DescriptionDescription
/p:/p: AdditionalDeploymentContributorArguments=(STRING)AdditionalDeploymentContributorArguments=(STRING) 為部署參與者指定其他部署參與者引數。Specifies additional deployment contributor arguments for the deployment contributors. 這應該是以分號區隔的值清單。This should be a semi-colon delimited list of values.
/p:/p: AdditionalDeploymentContributors=(STRING)AdditionalDeploymentContributors=(STRING) 指定部署 dacpac 時應該執行的其他部署參與者。Specifies additional deployment contributors, which should run when the dacpac is deployed. 這應該是以分號區隔的完整組建參與者名稱或識別碼清單。This should be a semi-colon delimited list of fully qualified build contributor names or IDs.
/p:/p: AllowDropBlockingAssemblies=(BOOLEAN)AllowDropBlockingAssemblies=(BOOLEAN) 這個屬性是供 SqlClr 部署用來使任何封鎖的組件會在部署計畫中卸除。This property is used by SqlClr deployment to cause any blocking assemblies to be dropped as part of the deployment plan. 根據預設,如果必須卸除任何參考組件,則該封鎖/參考組件會封鎖組件更新。By default, any blocking/referencing assemblies will block an assembly update if the referencing assembly needs to be dropped.
/p:/p: AllowIncompatiblePlatform=(BOOLEAN)AllowIncompatiblePlatform=(BOOLEAN) 指定儘管 SQL Server 平台不相容,是否仍要嘗試動作。Specifies whether to attempt the action despite incompatible SQL Server platforms.
/p:/p: AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN)AllowUnsafeRowLevelSecurityDataMovement=(BOOLEAN) 若此屬性設定為 true,請勿封鎖具有資料列層級安全性之資料表的資料動作。Do not block data motion on a table that has Row Level Security if this property is set to true. 預設值為 false。Default is false.
/p:/p: BackupDatabaseBeforeChanges=(BOOLEAN)BackupDatabaseBeforeChanges=(BOOLEAN) 在部署任何變更之前,先備份資料庫。Backups the database before deploying any changes.
/p:/p: BlockOnPossibleDataLoss=(BOOLEAN 'True')BlockOnPossibleDataLoss=(BOOLEAN 'True') 指定如果發行作業可能導致資料遺失,就應該終止發行事件。Specifies that the publish episode should be terminated if there is a possibility of data loss resulting from the publish.operation.
/p:/p: BlockWhenDriftDetected=(BOOLEAN 'True')BlockWhenDriftDetected=(BOOLEAN 'True') 指定是否封鎖更新結構描述不再符合註冊或已取消註冊的資料庫。Specifies whether to block updating a database whose schema no longer matches its registration or is unregistered.
/p:/p: CommandTimeout=(INT32 '60')CommandTimeout=(INT32 '60') 以秒為單位指定對 SQL Server 執行查詢時的命令逾時。Specifies the command timeout in seconds when executing queries against SQL Server.
/p:/p: CommentOutSetVarDeclarations=(BOOLEAN)CommentOutSetVarDeclarations=(BOOLEAN) 指定在產生的發行指令碼中是否應該將 SETVAR 變數的宣告標記為註解。Specifies whether the declaration of SETVAR variables should be commented out in the generated publish script. 如果您計畫在使用 SQLCMD.EXE 等工具進行發行時在命令列指定值,就可以選擇這種作法。You might choose to do this if you plan to specify the values on the command line when you publish by using a tool such as SQLCMD.EXE.
/p:/p: CompareUsingTargetCollation=(BOOLEAN)CompareUsingTargetCollation=(BOOLEAN) 這個設定表示資料庫的定序於部署期間的處理方式。如果目標資料庫的定序不符合來源所指定的定序,預設會更新目標資料庫的定序。This setting dictates how the database's collation is handled during deployment; by default the target database's collation will be updated if it does not match the collation specified by the source. 當設定這個選項時,則應該使用目標資料庫 (或伺服器) 的定序。When this option is set, the target database's (or server's) collation should be used.
/p:/p: CreateNewDatabase=(BOOLEAN)CreateNewDatabase=(BOOLEAN) 指定當您發行至資料庫時,應該更新目標資料庫或應該卸除並重新建立目標資料庫。Specifies whether the target database should be updated or whether it should be dropped and re-created when you publish to a database.
/p:/p: DatabaseEdition=({Basic|Standard|Premium|Default} 'Default')DatabaseEdition=({Basic|Standard|Premium|Default} 'Default') 定義 Azure SQL Database 的版本。Defines the edition of an Azure SQL Database.
/p:/p: DatabaseMaximumSize=(INT32)DatabaseMaximumSize=(INT32) 定義 Azure SQL Database 的大小上限 (以 GB 表示)。Defines the maximum size in GB of an Azure SQL Database.
/p:/p: DatabaseServiceObjective=(STRING)DatabaseServiceObjective=(STRING) 定義 Azure SQL Database 的效能等級,例如 "P0" 或 "S1"。Defines the performance level of an Azure SQL Database such as "P0" or "S1".
/p:/p: DeployDatabaseInSingleUserMode=(BOOLEAN)DeployDatabaseInSingleUserMode=(BOOLEAN) 若為 true,則資料庫會在設定為單一使用者模式後部署。if true, the database is set to Single User Mode before deploying.
/p:/p: DisableAndReenableDdlTriggers=(BOOLEAN 'True')DisableAndReenableDdlTriggers=(BOOLEAN 'True') 指定是否在發行程序開始時停用資料定義語言 (DDL) 觸發程序,並在發行動作結束時重新啟用。Specifies whether Data Definition Language (DDL) triggers are disabled at the beginning of the publish process and re-enabled at the end of the publish action.
/p:/p: DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True')DoNotAlterChangeDataCaptureObjects=(BOOLEAN 'True') 如果為 true,則不會改變異動資料擷取物件。If true, Change Data Capture objects are not altered.
/p:/p: DoNotAlterReplicatedObjects=(BOOLEAN 'True')DoNotAlterReplicatedObjects=(BOOLEAN 'True') 指定驗證期間是否識別有複寫的物件。Specifies whether objects that are replicated are identified during verification.
/p:/p: DoNotDropObjectType=(STRING)DoNotDropObjectType=(STRING) 物件型別,不應該捨棄當 DropObjectsNotInSource 為 true。An object type that should not be dropped when DropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DoNotDropObjectTypes=(STRING)DoNotDropObjectTypes=(STRING) 當 DropObjectsNotInSource 為 true 時不應捨棄的分號分隔物件類型清單。A semicolon-delimited list of object types that should not be dropped whenDropObjectsNotInSource is true. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: DropConstraintsNotInSource=(BOOLEAN 'True')DropConstraintsNotInSource=(BOOLEAN 'True') 指定在您將更新發佈至資料庫時,是否要從目標資料庫卸除資料庫快照集 (.dacpac) 檔案中不存在的條件約束。Specifies whether constraints that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you a database.
/p:/p: DropDmlTriggersNotInSource=(BOOLEAN 'True')DropDmlTriggersNotInSource=(BOOLEAN 'True') 指定在您將更新發佈至資料庫時,是否要從目標資料庫卸除資料庫快照集 (.dacpac) 檔案中不存在的 DML 觸發程序。Specifies whether DML triggers that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you a database.
/p:/p: DropExtendedPropertiesNotInSource=(BOOLEAN 'True')DropExtendedPropertiesNotInSource=(BOOLEAN 'True') 指定當您發行至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的擴充屬性。Specifies whether extended properties that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish to a database.
/p:/p: DropIndexesNotInSource=(BOOLEAN 'True')DropIndexesNotInSource=(BOOLEAN 'True') 指定在您將更新發佈至資料庫時,是否要從目標資料庫卸除資料庫快照集 (.dacpac) 檔案中不存在的索引。Specifies whether indexes that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you a database.
/p:/p: DropObjectsNotInSource=(BOOLEAN)DropObjectsNotInSource=(BOOLEAN) 指定在您將更新發佈至資料庫時,是否要從目標資料庫卸除資料庫快照集 (.dacpac) 檔案中不存在的物件。Specifies whether objects that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you a database. 此值的優先順序高過 DropExtendedProperties。This value takes precedence over DropExtendedProperties.
/p:/p: DropPermissionsNotInSource=(BOOLEAN)DropPermissionsNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除不存在資料庫快照集 (.dacpac) 檔案中的權限。Specifies whether permissions that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropRoleMembersNotInSource=(BOOLEAN)DropRoleMembersNotInSource=(BOOLEAN) 指定當您發行更新至資料庫時,是否要從目標資料庫中卸除資料庫快照集 (.dacpac) 檔案中沒有定義的角色成員。Specifies whether role members that are not defined in the database snapshot (.dacpac) file will be dropped from the target database when you publish updates to a database.
/p:/p: DropStatisticsNotInSource=(BOOLEAN 'True')DropStatisticsNotInSource=(BOOLEAN 'True') 指定在您將更新發佈至資料庫時,是否要從目標資料庫卸除資料庫快照集 (.dacpac) 檔案中不存在的統計資料。Specifies whether statistics that do not exist in the database snapshot (.dacpac) file will be dropped from the target database when you a database.
/p:/p: ExcludeObjectType=(STRING)ExcludeObjectType=(STRING) 部署期間應該忽略的物件類型。An object type that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object typenames are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: ExcludeObjectTypes=(STRING)ExcludeObjectTypes=(STRING) 以分號區隔的物件類型清單,列出部署期間應該忽略的物件類型。A semicolon-delimited list of object types that should be ignored during deployment. 有效的物件類型名稱為 Aggregates、ApplicationRoles、Assemblies、AsymmetricKeys、BrokerPriorities、Certificates、ColumnEncryptionKeys、ColumnMasterKeys、Contracts、DatabaseRoles、DatabaseTriggers、Defaults、ExtendedProperties、ExternalDataSources、ExternalFileFormats、ExternalTables、Filegroups、FileTables、FullTextCatalogs、FullTextStoplists、MessageTypes、PartitionFunctions、PartitionSchemes、Permissions、Queues、RemoteServiceBindings、RoleMembership、Rules、ScalarValuedFunctions、SearchPropertyLists、SecurityPolicies、Sequences、Services、Signatures、StoredProcedures、SymmetricKeys、Synonyms、Tables、TableValuedFunctions、UserDefinedDataTypes、UserDefinedTableTypes、ClrUserDefinedTypes、Users、Views、XmlSchemaCollections、Audits、Credentials、CryptographicProviders、DatabaseAuditSpecifications、DatabaseScopedCredentials、Endpoints、ErrorMessages、EventNotifications、EventSessions、LinkedServerLogins、LinkedServers、Logins、Routes、ServerAuditSpecifications、ServerRoleMembership、ServerRoles、ServerTriggers。Valid object type names are Aggregates, ApplicationRoles, Assemblies, AsymmetricKeys, BrokerPriorities, Certificates, ColumnEncryptionKeys, ColumnMasterKeys, Contracts, DatabaseRoles, DatabaseTriggers, Defaults, ExtendedProperties, ExternalDataSources, ExternalFileFormats, ExternalTables, Filegroups, FileTables, FullTextCatalogs, FullTextStoplists, MessageTypes, PartitionFunctions, PartitionSchemes, Permissions, Queues, RemoteServiceBindings, RoleMembership, Rules, ScalarValuedFunctions, SearchPropertyLists, SecurityPolicies, Sequences, Services, Signatures, StoredProcedures, SymmetricKeys, Synonyms, Tables, TableValuedFunctions, UserDefinedDataTypes, UserDefinedTableTypes, ClrUserDefinedTypes, Users, Views, XmlSchemaCollections, Audits, Credentials, CryptographicProviders, DatabaseAuditSpecifications, DatabaseScopedCredentials, Endpoints, ErrorMessages, EventNotifications, EventSessions, LinkedServerLogins, LinkedServers, Logins, Routes, ServerAuditSpecifications, ServerRoleMembership, ServerRoles, ServerTriggers.
/p:/p: GenerateSmartDefaults=(BOOLEAN)GenerateSmartDefaults=(BOOLEAN) 在更新含有資料且資料行不允許 null 值的資料表時,自動提供預設值。Automatically provides a default value when updating a table that containsdata with a column that does not allow null values.
/p:/p: IgnoreAnsiNulls=(BOOLEAN 'True')IgnoreAnsiNulls=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 ANSI NULLS 設定的差異。Specifies whether differences in the ANSI NULLS setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreAuthorizer=(BOOLEAN)IgnoreAuthorizer=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新授權者的差異。Specifies whether differences in the Authorizer should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnCollation=(BOOLEAN)IgnoreColumnCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料行定序的差異。Specifies whether differences in the column collations should be ignored or updated when you publish to a database.
/p:/p: IgnoreColumnOrder=(BOOLEAN)IgnoreColumnOrder=(BOOLEAN) 指定當您發行至資料庫時,是否應略過或更新資料表資料行順序的差異。Specifies whether differences in table column order should be ignored or updated when you publish to a database.
/p:/p: IgnoreComments=(BOOLEAN)IgnoreComments=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新註解的差異。Specifies whether differences in the comments should be ignored or updated when you publish to a database.
/p:/p: IgnoreCryptographicProviderFilePath=(BOOLEAN 'True')IgnoreCryptographicProviderFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新密碼編譯提供者之檔案路徑的差異。Specifies whether differences in the file path for the cryptographic provider should be ignored or updated when you publish to a database.
/p:/p: IgnoreDdlTriggerOrder=(BOOLEAN)IgnoreDdlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫或伺服器時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序的順序差異。Specifies whether differences in the order of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database or server.
/p:/p: IgnoreDdlTriggerState=(BOOLEAN)IgnoreDdlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料定義語言 (Data Definition Language) (DDL) 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of Data Definition Language (DDL) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDefaultSchema=(BOOLEAN)IgnoreDefaultSchema=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新預設結構描述的差異。Specifies whether differences in the default schema should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerOrder=(BOOLEAN)IgnoreDmlTriggerOrder=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料操作語言 (DML) 觸發程序的順序差異。Specifies whether differences in the order of Data Manipulation Language (DML) triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreDmlTriggerState=(BOOLEAN)IgnoreDmlTriggerState=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新 DML 觸發程序之啟用或停用狀態的差異。Specifies whether differences in the enabled or disabled state of DML triggers should be ignored or updated when you publish to a database.
/p:/p: IgnoreExtendedProperties=(BOOLEAN)IgnoreExtendedProperties=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新擴充屬性的差異。Specifies whether differences in the extended properties should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileAndLogFilePath=(BOOLEAN 'True')IgnoreFileAndLogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新檔案和記錄檔之路徑的差異。Specifies whether differences in the paths for files and log files should be ignored or updated when you publish to a database.
/p:/p: IgnoreFilegroupPlacement=(BOOLEAN 'True')IgnoreFilegroupPlacement=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 FILEGROUP 中物件位置的差異。Specifies whether differences in the placement of objects in FILEGROUPs should be ignored or updated when you publish to a database.
/p:/p: IgnoreFileSize=(BOOLEAN 'True')IgnoreFileSize=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略檔案大小的差異或應該發出警告。Specifies whether differences in the file sizes should be ignored or whether a warning should be issued when you publish to a database.
/p:/p: IgnoreFillFactor=(BOOLEAN 'True')IgnoreFillFactor=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略索引儲存體之填滿因數的差異或應該發出警告。Specifies whether differences in the fill factor for index storage should be ignored or whether a warning should be issued when you publish.
/p:/p: IgnoreFullTextCatalogFilePath=(BOOLEAN 'True')IgnoreFullTextCatalogFilePath=(BOOLEAN 'True') 指定當您發行至資料庫時,是否忽略全文檢索檔案路徑的差異,或是對此發出警告。Specifies whether differences in the file path for the full-text be ignored or whether a warning should be issued when you a database.
/p:/p: IgnoreIdentitySeed=(BOOLEAN)IgnoreIdentitySeed=(BOOLEAN) 指定當您發行更新至資料庫時,應該忽略或更新識別欄位之種子的差異。Specifies whether differences in the seed for an identity column should be ignored or updated when you publish updates to a database.
/p:/p: IgnoreIncrement=(BOOLEAN)IgnoreIncrement=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新識別欄位之增量的差異。Specifies whether differences in the increment for an identity column should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexOptions=(BOOLEAN)IgnoreIndexOptions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引選項的差異。Specifies whether differences in the index options should be ignored or updated when you publish to a database.
/p:/p: IgnoreIndexPadding=(BOOLEAN 'True')IgnoreIndexPadding=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新索引填補的差異。Specifies whether differences in the index padding should be ignored or updated when you publish to a database.
/p:/p: IgnoreKeywordCasing=(BOOLEAN 'True')IgnoreKeywordCasing=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新關鍵字之大小寫的差異。Specifies whether differences in the casing of keywords should be ignored or updated when you publish to a database.
/p:/p: IgnoreLockHintsOnIndexes=(BOOLEAN)IgnoreLockHintsOnIndexes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新索引之鎖定提示的差異。Specifies whether differences in the lock hints on indexes should be ignored or updated when you publish to a database.
/p:/p: IgnoreLoginSids=(BOOLEAN 'True')IgnoreLoginSids=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新安全性識別碼 (SID) 的差異。Specifies whether differences in the security identification number (SID) should be ignored or updated when you publish to a database.
/p:/p: IgnoreNotForReplication=(BOOLEAN)IgnoreNotForReplication=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新不可複寫設定。Specifies whether the not for replication settings should be ignored or updated when you publish to a database.
/p:/p: IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True')IgnoreObjectPlacementOnPartitionScheme=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新物件在資料分割配置上的位置。Specifies whether an object's placement on a partition scheme should be ignored or updated when you publish to a database.
/p:/p: IgnorePartitionSchemes=(BOOLEAN)IgnorePartitionSchemes=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料分割配置和函式的差異。Specifies whether differences in partition schemes and functions should be ignored or updated when you publish to a database.
/p:/p: IgnorePermissions=(BOOLEAN)IgnorePermissions=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新權限的差異。Specifies whether differences in the permissions should be ignored or updated when you publish to a database.
/p:/p: IgnoreQuotedIdentifiers=(BOOLEAN 'True')IgnoreQuotedIdentifiers=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新引號識別項設定的差異。Specifies whether differences in the quoted identifiers setting should be ignored or updated when you publish to a database.
/p:/p: IgnoreRoleMembership=(BOOLEAN)IgnoreRoleMembership=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新登入之角色成員資格的差異。Specifies whether differences in the role membership of logins should be ignored or updated when you publish to a database.
/p:/p: IgnoreRouteLifetime=(BOOLEAN 'True')IgnoreRouteLifetime=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 SQL Server 將路由保留在路由表中之時間長短的差異。Specifies whether differences in the amount of time that SQL Server retains the route in the routing table should be ignored or updated when you publish to a database.
/p:/p: IgnoreSemicolonBetweenStatements=(BOOLEAN 'True')IgnoreSemicolonBetweenStatements=(BOOLEAN 'True') 指定當您發行至資料庫時,應該忽略或更新 T-SQL 陳述式間之分號的差異。Specifies whether differences in the semi-colons between T-SQL statements will be ignored or updated when you publish to a database.
/p:/p: IgnoreTableOptions=(BOOLEAN)IgnoreTableOptions=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新資料表選項的差異。Specifies whether differences in the table options will be ignored or updated when you publish to a database.
/p:/p: IgnoreUserSettingsObjects=(BOOLEAN)IgnoreUserSettingsObjects=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新使用者設定物件的差異。Specifies whether differences in the user settings objects will be ignored or updated when you publish to a database.
/p:/p: IgnoreWhitespace=(BOOLEAN 'True')IgnoreWhitespace=(BOOLEAN 'True') 指定當您發行至資料庫時,將忽略或更新空白字元的差異。Specifies whether differences in white space will be ignored or updated when you publish to a database.
/p:/p: IgnoreWithNocheckOnCheckConstraints=(BOOLEAN)IgnoreWithNocheckOnCheckConstraints=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新檢查條件約束之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for check constraints will be ignored or updated when you publish.
/p:/p: IgnoreWithNocheckOnForeignKeys=(BOOLEAN)IgnoreWithNocheckOnForeignKeys=(BOOLEAN) 指定當您發行至資料庫時,將忽略或更新外部索引鍵之 WITH NOCHECK 子句值的差異。Specifies whether differences in the value of the WITH NOCHECK clause for foreign keys will be ignored or updated when you publish to a database.
/p:/p: IncludeCompositeObjects=(BOOLEAN)IncludeCompositeObjects=(BOOLEAN) 將所有複合項目包含在單一發行作業中。Include all composite elements as part of a single publish operation.
/p:/p: IncludeTransactionalScripts=(BOOLEAN)IncludeTransactionalScripts=(BOOLEAN) 指定當您發行至資料庫時,是否應該盡可能使用交易陳述式。Specifies whether transactional statements should be used where possible when you publish to a database.
/p:/p: NoAlterStatementsToChangeClrTypes=(BOOLEAN)NoAlterStatementsToChangeClrTypes=(BOOLEAN) 指定發行在發現差異時一定要卸除並重新建立組件,而不是發出 ALTER ASSEMBLY 陳述式。Specifies that publish should always drop and re-create an assembly if there is a difference instead of issuing an ALTER ASSEMBLY statement.
/p:/p: PopulateFilesOnFileGroups=(BOOLEAN 'True')PopulateFilesOnFileGroups=(BOOLEAN 'True') 指定在目標資料庫中建立新 FileGroup 時,是否一併建立新檔案。Specifies whether a new file is also created when a new FileGroup is created in the target database.
/p:/p: RegisterDataTierApplication=(BOOLEAN)RegisterDataTierApplication=(BOOLEAN) 指定結構描述是否向資料庫伺服器註冊。Specifies whether the schema is registered with the database server.
/p:/p: RunDeploymentPlanExecutors=(BOOLEAN)RunDeploymentPlanExecutors=(BOOLEAN) 指定執行其他作業時,是否應該執行 DeploymentPlanExecutor 參與者。Specifies whether DeploymentPlanExecutor contributors should be run when other operations are executed.
/p:/p: ScriptDatabaseCollation=(BOOLEAN)ScriptDatabaseCollation=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫定序的差異。Specifies whether differences in the database collation should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseCompatibility=(BOOLEAN)ScriptDatabaseCompatibility=(BOOLEAN) 指定當您發行至資料庫時,應該忽略或更新資料庫相容性的差異。Specifies whether differences in the database compatibility should be ignored or updated when you publish to a database.
/p:/p: ScriptDatabaseOptions=(BOOLEAN 'True')ScriptDatabaseOptions=(BOOLEAN 'True') 指定是否應該在發行動作中設定或更新目標資料庫屬性。Specifies whether target database properties should be set or updated as part of the publish action.
/p:/p: ScriptDeployStateChecks=(BOOLEAN)ScriptDeployStateChecks=(BOOLEAN) 指定是否在發行指令碼中產生陳述式,來驗證資料庫名稱和伺服器名稱是否符合資料庫專案中指定的名稱。Specifies whether statements are generated in the publish script to verify that the database name and server name match the names specified in the database project.
/p:/p: ScriptFileSize=(BOOLEAN)ScriptFileSize=(BOOLEAN) 控制將檔案加入至檔案群組時是否指定大小。Controls whether size is specified when adding a file to a filegroup.
/p:/p: ScriptNewConstraintValidation=(BOOLEAN 'True')ScriptNewConstraintValidation=(BOOLEAN 'True') 在發行結束時,所有會驗證條件約束當做單一集合,避免檢查或外部索引鍵條件約束在發行所造成的資料錯誤。At the end of publish all of the constraints will be verified as one set, avoiding data errors caused by a check or foreign key constraint in the middle of publish. 如果設為 False,則會發行您的條件約束,但不檢查對應的資料。If set to False, your constraints are published without checking the corresponding data.
/p:/p: ScriptRefreshModule=(BOOLEAN 'True')ScriptRefreshModule=(BOOLEAN 'True') 在發行指令碼的結尾包含重新整理陳述式。Include refresh statements at the end of the publish script.
/p:/p: Storage=({File|Memory})Storage=({File|Memory}) 指定在建置資料庫模型時,如何儲存項目。Specifies how elements are stored when building the database model. 基於效能考量,預設值為 InMemory。For performance reasons the default is InMemory. 若為大型資料庫,則需要檔案型儲存體。For large databases, File backed storage is required.
/p:/p: TreatVerificationErrorsAsWarnings=(BOOLEAN)TreatVerificationErrorsAsWarnings=(BOOLEAN) 指定驗證是否發行期間發生的錯誤應該視為警告。Specifies whether errors encountered during publish verification should be treated as warnings. 系統會先針對產生的部署計畫執行檢查,再針對您的目標資料庫執行計畫。The check is performed against the generated deployment plan before the plan is executed against your target database. 計畫驗證會偵測出遺漏僅限於目標的物件 (如索引) 這類必須卸除後才能進行變更的問題。Plan verification detects problems such as the loss of target-only objects (such as indexes) that must be dropped to make a change. 驗證也會偵測因為參考複合專案而存在相依性 (如資料表或檢視),但卻不存在於目標資料庫中的情況。Verification will also detect situations where dependencies (such as a table or view) exist because of a reference to a composite project, but do not exist in the target database. 您可以選擇這樣做來取得所有的問題,而不是第一次發生錯誤時停止發行動作的完整清單。You might choose to do this to get a complete list of all issues, instead of having the publish action stop on the first error.
/p:/p: UnmodifiableObjectWarnings=(BOOLEAN 'True')UnmodifiableObjectWarnings=(BOOLEAN 'True') 指定在無法修改的物件中發現差異時 (例如檔案的檔案大小或檔案路徑不同) 是否應該產生警告。Specifies whether warnings should be generated when differences are found in objects that cannot be modified, for example, if the file size or file paths were different for a file.
/p:/p: VerifyCollationCompatibility=(BOOLEAN 'True')VerifyCollationCompatibility=(BOOLEAN 'True') 指定是否驗證定序相容性。Specifies whether collation compatibility is verified.
/p:/p: VerifyDeployment=(BOOLEAN 'True')VerifyDeployment=(BOOLEAN 'True') 指定是否應該在發行前執行檢查,以便在出現阻止發行成功的問題時停止發行動作。Specifies whether checks should be performed before publishing that will stop the publish action if issues are present that might block successful publishing. 例如,如果目標資料庫的外部索引鍵不存在資料庫專案中,因而在您發行時造成錯誤,則發行動作可能會停止。For example, your publish action might stop if you have foreign keys on the target database that do not exist in the database project, and that causes errors when you publish.