Share via

ConnectToSourceSqlServerTaskInput interface

  • Reference
Package:
@azure/arm-datamigration

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

Properties

checkPermissionsGroup

Permission group for validations. Possible values include: 'Default', 'MigrationFromSqlServerToAzureDB', 'MigrationFromSqlServerToAzureMI', 'MigrationFromMySQLToAzureDBForMySQL'
collectAgentJobs

Flag for whether to collect agent jobs from source server. Default value: false.
collectDatabases

Flag for whether to collect databases from source server. Default value: true.
collectLogins

Flag for whether to collect logins from source server. Default value: false.
collectTdeCertificateInfo

Flag for whether to collect TDE Certificate names from source server. Default value: false.
sourceConnectionInfo

Connection information for Source SQL Server
validateSsisCatalogOnly

Flag for whether to validate SSIS catalog is reachable on the source server. Default value: false.

Property Details

checkPermissionsGroup

Permission group for validations. Possible values include: 'Default', 'MigrationFromSqlServerToAzureDB', 'MigrationFromSqlServerToAzureMI', 'MigrationFromMySQLToAzureDBForMySQL'

checkPermissionsGroup?: ServerLevelPermissionsGroup

Property Value

ServerLevelPermissionsGroup

collectAgentJobs

Flag for whether to collect agent jobs from source server. Default value: false.

collectAgentJobs?: boolean

Property Value

boolean

collectDatabases

Flag for whether to collect databases from source server. Default value: true.

collectDatabases?: boolean

Property Value

boolean

collectLogins

Flag for whether to collect logins from source server. Default value: false.

collectLogins?: boolean

Property Value

boolean

collectTdeCertificateInfo

Flag for whether to collect TDE Certificate names from source server. Default value: false.

collectTdeCertificateInfo?: boolean

Property Value

boolean

sourceConnectionInfo

Connection information for Source SQL Server

sourceConnectionInfo: SqlConnectionInfo

Property Value

SqlConnectionInfo

validateSsisCatalogOnly

Flag for whether to validate SSIS catalog is reachable on the source server. Default value: false.

validateSsisCatalogOnly?: boolean

Property Value

boolean