SQL Data Catalog

Copy-Classification

Copy classification across databases with the same schema.

Syntax

Copy-Classification [-SourceInstanceName] <string> [-SourceDatabaseName] <string> [-DestinationInstanceName] <string> [-DestinationDatabaseName] <string> [<CommonParameters>]

Description

Copy classification across databases with the same schema. The classification is stored in SQL Data Catalog only, no live database is modified.

Parameters

-SourceInstanceName <String>

The fully-qualified name of the source SQL Server instance. For a named instance, this should take the form 'fully-qualified-host-name\instance-name' (e.g. "myserver.mydomain.com\myinstance"). For the default instance on a machine, just the fully-qualified name of the machine will suffice (e.g. "myserver.mydomain.com").

Aliases None
Required? true
Position? 1
Default Value None
Accept Pipeline Input False
Accept Wildcard Characters false

-SourceDatabaseName <String>

Source database name.

Aliases None
Required? true
Position? 2
Default Value None
Accept Pipeline Input False
Accept Wildcard Characters false

-DestinationInstanceName <String>

The fully-qualified name of the destination SQL Server instance. For a named instance, this should take the form 'fully-qualified-host-name\instance-name' (e.g. "myserver.mydomain.com\myinstance"). For the default instance on a machine, just the fully-qualified name of the machine will suffice (e.g. "myserver.mydomain.com").

Aliases None
Required? true
Position? 3
Default Value None
Accept Pipeline Input False
Accept Wildcard Characters false

-DestinationDatabaseName <String>

Destination database name.

Aliases None
Required? true
Position? 4
Default Value None
Accept Pipeline Input False
Accept Wildcard Characters false

-ProgressAction <ActionPreference>

{{ Fill ProgressAction Description }}

Aliases None
Required? false
Position? named
Default Value None
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.

Examples

-------------------------- EXAMPLE 1 --------------------------

Copy-Classification -sourceInstanceName "(local)\MSSQL2017" -sourceDatabaseName "sourceDB" -destinationInstanceName "(local)\MSSQL2017" -destinationDatabaseName "destinationDB"

Duplicates classification for the source database and assigns it to the target database.


Didn't find what you were looking for?