ConnectToSourceSqlServerTaskInput interface

Input for the task that validates connection to SQL Server and also validates source server requirements

Properties

checkPermissionsGroup

Permission group for validations

collectAgentJobs

Flag for whether to collect agent jobs from source server.

collectDatabases

Flag for whether to collect databases from source server.

collectLogins

Flag for whether to collect logins from source server.

collectTdeCertificateInfo

Flag for whether to collect TDE Certificate names from source server.

sourceConnectionInfo

Connection information for Source SQL Server

validateSsisCatalogOnly

Flag for whether to validate SSIS catalog is reachable on the source server.

Property Details

checkPermissionsGroup

Permission group for validations

checkPermissionsGroup?: ServerLevelPermissionsGroup

Property Value

collectAgentJobs

Flag for whether to collect agent jobs from source server.

collectAgentJobs?: boolean

Property Value

boolean

collectDatabases

Flag for whether to collect databases from source server.

collectDatabases?: boolean

Property Value

boolean

collectLogins

Flag for whether to collect logins from source server.

collectLogins?: boolean

Property Value

boolean

collectTdeCertificateInfo

Flag for whether to collect TDE Certificate names from source server.

collectTdeCertificateInfo?: boolean

Property Value

boolean

sourceConnectionInfo

Connection information for Source SQL Server

sourceConnectionInfo: SqlConnectionInfo

Property Value

validateSsisCatalogOnly

Flag for whether to validate SSIS catalog is reachable on the source server.

validateSsisCatalogOnly?: boolean

Property Value

boolean