Update-ClassificationInLiveDatabase
Published 25 September 2019
Push sensitivity label and information type for columns to the live database.
Syntax
Update-ClassificationInLiveDatabase [-InstanceName] <string> [-DatabaseName] <string> [[-UserName] <string>] [[-Password] <string>] [-ForceUpdate] [<CommonParameters>]
Description
Push sensitivity label and information type for columns of a given database from SQL Data Catalog to the live database. It uses the ADD SENSITIVITY CLASSIFICATION syntax, on versions where that is supported. Otherwise it pushes to the database's extended properties.
Parameters
-InstanceName
<String>
Fully qualified domain name of the instance
| Aliases | None |
| Required? | true |
| Position? | 1 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-DatabaseName
<String>
Name of the database
| Aliases | None |
| Required? | true |
| Position? | 2 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-UserName
<String>
User name. Do not use this parameter for Windows Authentication
| Aliases | None |
| Required? | false |
| Position? | 3 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-Password
<String>
Password. Do not use this parameter for Windows Authentication
| Aliases | None |
| Required? | false |
| Position? | 4 |
| Default Value | None |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
-ForceUpdate
<SwitchParameter>
Use this flag to overwrite any existing classification stored in extended properties by the classification from the SQL Data Catalog. Note that any unassigned classifications in Data Catalog will also remove the classifications in extended properties. This parameter has no effect when using the ADD SENSITIVITY CLASSIFICATION syntax.
| Aliases | None |
| Required? | false |
| Position? | named |
| Default Value | False |
| Accept Pipeline Input | False |
| Accept Wildcard Characters | false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see http://technet.microsoft.com/en-us/library/hh847884.aspx.
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
-
None.
You cannot pipe input to this cmdlet.
Return values
The output type is the type of the objects that the cmdlet emits.
-
None.
You cannot pipe input to this cmdlet.
Examples
-------------------------- EXAMPLE 1 --------------------------
Update-ClassificationInLiveDatabase -instanceName "sqlserver\sql2016" -databaseName "WideWorldImporters" -user "admin" -password "P@ssword123"
Sets the classification in the provided database with the values stored in SQL Data Catalog, but only for columns that don't have it set.
-------------------------- EXAMPLE 2 --------------------------
Update-ClassificationInLiveDatabase -instanceName "sqlserver\sql2016" -databaseName "WideWorldImporters" -user "admin" -password "P@ssword123" -forceUpdate
Overwrites the classification in the provided database with values stored in SQL Data Catalog.
