Start scan of a registered database.

Syntax

Start-ClassificationDatabaseScan [-FullyQualifiedInstanceName] <string> [-DatabaseName] <string> [<CommonParameters>]

Description

Scans the database for new tables and columns. Updates data stored in SQL Data Catalog based on metadata read from the live database provided.

Parameters

-FullyQualifiedInstanceName <String>

The fully-qualified name of the SQL Server instance to be registered. 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").

-DatabaseName <String>

The fully-qualified name of the database to be registered.

-ProgressAction <ActionPreference>

{{ Fill ProgressAction Description }}

<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.

• A hashtable with the following properties:

  - type: string

  - title: string

  - status: int

  - detail: string

  - instance: string

Examples

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

Start-ClassificationDatabaseScan -FullyQualifiedInstanceName 'mysqlserver.mydomain.com\myinstancename' -DatabaseName 'TestDB'

Start a scan of a database "myinstancename\TestDB" running on the "mysqlserver.mydomain.com" machine, which results in updating data about this database stored in SQL Data Catalog.