Azure Native

Pulumi Official
Package maintained by Pulumi
v1.64.1 published on Wednesday, May 18, 2022 by Pulumi

getDatabaseMigrationsSqlDb

Database Migration Resource for SQL Database. API Version: 2022-03-30-preview.

Using getDatabaseMigrationsSqlDb

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getDatabaseMigrationsSqlDb(args: GetDatabaseMigrationsSqlDbArgs, opts?: InvokeOptions): Promise<GetDatabaseMigrationsSqlDbResult>
function getDatabaseMigrationsSqlDbOutput(args: GetDatabaseMigrationsSqlDbOutputArgs, opts?: InvokeOptions): Output<GetDatabaseMigrationsSqlDbResult>
def get_database_migrations_sql_db(expand: Optional[str] = None,
                                   migration_operation_id: Optional[str] = None,
                                   resource_group_name: Optional[str] = None,
                                   sql_db_instance_name: Optional[str] = None,
                                   target_db_name: Optional[str] = None,
                                   opts: Optional[InvokeOptions] = None) -> GetDatabaseMigrationsSqlDbResult
def get_database_migrations_sql_db_output(expand: Optional[pulumi.Input[str]] = None,
                                   migration_operation_id: Optional[pulumi.Input[str]] = None,
                                   resource_group_name: Optional[pulumi.Input[str]] = None,
                                   sql_db_instance_name: Optional[pulumi.Input[str]] = None,
                                   target_db_name: Optional[pulumi.Input[str]] = None,
                                   opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseMigrationsSqlDbResult]
func LookupDatabaseMigrationsSqlDb(ctx *Context, args *LookupDatabaseMigrationsSqlDbArgs, opts ...InvokeOption) (*LookupDatabaseMigrationsSqlDbResult, error)
func LookupDatabaseMigrationsSqlDbOutput(ctx *Context, args *LookupDatabaseMigrationsSqlDbOutputArgs, opts ...InvokeOption) LookupDatabaseMigrationsSqlDbResultOutput

> Note: This function is named LookupDatabaseMigrationsSqlDb in the Go SDK.

public static class GetDatabaseMigrationsSqlDb 
{
    public static Task<GetDatabaseMigrationsSqlDbResult> InvokeAsync(GetDatabaseMigrationsSqlDbArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseMigrationsSqlDbResult> Invoke(GetDatabaseMigrationsSqlDbInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDatabaseMigrationsSqlDbResult> getDatabaseMigrationsSqlDb(GetDatabaseMigrationsSqlDbArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
Fn::Invoke:
  Function: azure-native:datamigration:getDatabaseMigrationsSqlDb
  Arguments:
    # Arguments dictionary

The following arguments are supported:

ResourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

SqlDbInstanceName string
TargetDbName string

The name of the target database.

Expand string

Complete migration details be included in the response.

MigrationOperationId string

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

ResourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

SqlDbInstanceName string
TargetDbName string

The name of the target database.

Expand string

Complete migration details be included in the response.

MigrationOperationId string

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

resourceGroupName String

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sqlDbInstanceName String
targetDbName String

The name of the target database.

expand String

Complete migration details be included in the response.

migrationOperationId String

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

resourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sqlDbInstanceName string
targetDbName string

The name of the target database.

expand string

Complete migration details be included in the response.

migrationOperationId string

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

resource_group_name str

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sql_db_instance_name str
target_db_name str

The name of the target database.

expand str

Complete migration details be included in the response.

migration_operation_id str

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

resourceGroupName String

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sqlDbInstanceName String
targetDbName String

The name of the target database.

expand String

Complete migration details be included in the response.

migrationOperationId String

Optional migration operation ID. If this is provided, then details of migration operation for that ID are retrieved. If not provided (default), then details related to most recent or current operation are retrieved.

getDatabaseMigrationsSqlDb Result

The following output properties are available:

Id string
Name string
Properties Pulumi.AzureNative.DataMigration.Outputs.DatabaseMigrationPropertiesSqlDbResponse

Database Migration Resource properties for SQL database.

SystemData Pulumi.AzureNative.DataMigration.Outputs.SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

Type string
Id string
Name string
Properties DatabaseMigrationPropertiesSqlDbResponse

Database Migration Resource properties for SQL database.

SystemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

Type string
id String
name String
properties DatabaseMigrationPropertiesSqlDbResponse

Database Migration Resource properties for SQL database.

systemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type String
id string
name string
properties DatabaseMigrationPropertiesSqlDbResponse

Database Migration Resource properties for SQL database.

systemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type string
id str
name str
properties DatabaseMigrationPropertiesSqlDbResponse

Database Migration Resource properties for SQL database.

system_data SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type str
id String
name String
properties Property Map

Database Migration Resource properties for SQL database.

systemData Property Map

Metadata pertaining to creation and last modification of the resource.

type String

Supporting Types

CopyProgressDetailsResponse

CopyDuration int

Copy Duration in seconds

CopyStart string

Copy Start

CopyThroughput double

Copy throughput in KBps

DataRead double

Bytes read

DataWritten double

Bytes written

ParallelCopyType string

Type of parallel copy (Dynamic range, Physical partition, none).

RowsCopied double

Rows Copied

RowsRead double

Rows read

Status string

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

TableName string

Table Name

UsedParallelCopies int

The degree of parallelization.

CopyDuration int

Copy Duration in seconds

CopyStart string

Copy Start

CopyThroughput float64

Copy throughput in KBps

DataRead float64

Bytes read

DataWritten float64

Bytes written

ParallelCopyType string

Type of parallel copy (Dynamic range, Physical partition, none).

RowsCopied float64

Rows Copied

RowsRead float64

Rows read

Status string

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

TableName string

Table Name

UsedParallelCopies int

The degree of parallelization.

copyDuration Integer

Copy Duration in seconds

copyStart String

Copy Start

copyThroughput Double

Copy throughput in KBps

dataRead Double

Bytes read

dataWritten Double

Bytes written

parallelCopyType String

Type of parallel copy (Dynamic range, Physical partition, none).

rowsCopied Double

Rows Copied

rowsRead Double

Rows read

status String

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

tableName String

Table Name

usedParallelCopies Integer

The degree of parallelization.

copyDuration number

Copy Duration in seconds

copyStart string

Copy Start

copyThroughput number

Copy throughput in KBps

dataRead number

Bytes read

dataWritten number

Bytes written

parallelCopyType string

Type of parallel copy (Dynamic range, Physical partition, none).

rowsCopied number

Rows Copied

rowsRead number

Rows read

status string

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

tableName string

Table Name

usedParallelCopies number

The degree of parallelization.

copy_duration int

Copy Duration in seconds

copy_start str

Copy Start

copy_throughput float

Copy throughput in KBps

data_read float

Bytes read

data_written float

Bytes written

parallel_copy_type str

Type of parallel copy (Dynamic range, Physical partition, none).

rows_copied float

Rows Copied

rows_read float

Rows read

status str

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

table_name str

Table Name

used_parallel_copies int

The degree of parallelization.

copyDuration Number

Copy Duration in seconds

copyStart String

Copy Start

copyThroughput Number

Copy throughput in KBps

dataRead Number

Bytes read

dataWritten Number

Bytes written

parallelCopyType String

Type of parallel copy (Dynamic range, Physical partition, none).

rowsCopied Number

Rows Copied

rowsRead Number

Rows read

status String

Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).

tableName String

Table Name

usedParallelCopies Number

The degree of parallelization.

DatabaseMigrationPropertiesSqlDbResponse

EndedOn string

Database migration end time.

MigrationFailureError Pulumi.AzureNative.DataMigration.Inputs.ErrorInfoResponse

Error details in case of migration failure.

MigrationStatus string

Migration status.

MigrationStatusDetails Pulumi.AzureNative.DataMigration.Inputs.SqlDbMigrationStatusDetailsResponse

Detailed migration status. Not included by default.

OfflineConfiguration Pulumi.AzureNative.DataMigration.Inputs.SqlDbOfflineConfigurationResponse

Offline configuration.

ProvisioningState string

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

SourceServerName string

Name of the source sql server.

StartedOn string

Database migration start time.

MigrationOperationId string

ID tracking current migration operation.

MigrationService string

Resource Id of the Migration Service.

ProvisioningError string

Error message for migration provisioning failure, if any.

Scope string

Resource Id of the target resource (SQL VM or SQL Managed Instance).

SourceDatabaseName string

Name of the source database.

SourceSqlConnection Pulumi.AzureNative.DataMigration.Inputs.SqlConnectionInformationResponse

Source SQL Server connection details.

TableList List<string>

List of tables to copy.

TargetDatabaseCollation string

Database collation to be used for the target database.

TargetSqlConnection Pulumi.AzureNative.DataMigration.Inputs.SqlConnectionInformationResponse

Target SQL DB connection details.

EndedOn string

Database migration end time.

MigrationFailureError ErrorInfoResponse

Error details in case of migration failure.

MigrationStatus string

Migration status.

MigrationStatusDetails SqlDbMigrationStatusDetailsResponse

Detailed migration status. Not included by default.

OfflineConfiguration SqlDbOfflineConfigurationResponse

Offline configuration.

ProvisioningState string

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

SourceServerName string

Name of the source sql server.

StartedOn string

Database migration start time.

MigrationOperationId string

ID tracking current migration operation.

MigrationService string

Resource Id of the Migration Service.

ProvisioningError string

Error message for migration provisioning failure, if any.

Scope string

Resource Id of the target resource (SQL VM or SQL Managed Instance).

SourceDatabaseName string

Name of the source database.

SourceSqlConnection SqlConnectionInformationResponse

Source SQL Server connection details.

TableList []string

List of tables to copy.

TargetDatabaseCollation string

Database collation to be used for the target database.

TargetSqlConnection SqlConnectionInformationResponse

Target SQL DB connection details.

endedOn String

Database migration end time.

migrationFailureError ErrorInfoResponse

Error details in case of migration failure.

migrationStatus String

Migration status.

migrationStatusDetails SqlDbMigrationStatusDetailsResponse

Detailed migration status. Not included by default.

offlineConfiguration SqlDbOfflineConfigurationResponse

Offline configuration.

provisioningState String

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

sourceServerName String

Name of the source sql server.

startedOn String

Database migration start time.

migrationOperationId String

ID tracking current migration operation.

migrationService String

Resource Id of the Migration Service.

provisioningError String

Error message for migration provisioning failure, if any.

scope String

Resource Id of the target resource (SQL VM or SQL Managed Instance).

sourceDatabaseName String

Name of the source database.

sourceSqlConnection SqlConnectionInformationResponse

Source SQL Server connection details.

tableList List<String>

List of tables to copy.

targetDatabaseCollation String

Database collation to be used for the target database.

targetSqlConnection SqlConnectionInformationResponse

Target SQL DB connection details.

endedOn string

Database migration end time.

migrationFailureError ErrorInfoResponse

Error details in case of migration failure.

migrationStatus string

Migration status.

migrationStatusDetails SqlDbMigrationStatusDetailsResponse

Detailed migration status. Not included by default.

offlineConfiguration SqlDbOfflineConfigurationResponse

Offline configuration.

provisioningState string

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

sourceServerName string

Name of the source sql server.

startedOn string

Database migration start time.

migrationOperationId string

ID tracking current migration operation.

migrationService string

Resource Id of the Migration Service.

provisioningError string

Error message for migration provisioning failure, if any.

scope string

Resource Id of the target resource (SQL VM or SQL Managed Instance).

sourceDatabaseName string

Name of the source database.

sourceSqlConnection SqlConnectionInformationResponse

Source SQL Server connection details.

tableList string[]

List of tables to copy.

targetDatabaseCollation string

Database collation to be used for the target database.

targetSqlConnection SqlConnectionInformationResponse

Target SQL DB connection details.

ended_on str

Database migration end time.

migration_failure_error ErrorInfoResponse

Error details in case of migration failure.

migration_status str

Migration status.

migration_status_details SqlDbMigrationStatusDetailsResponse

Detailed migration status. Not included by default.

offline_configuration SqlDbOfflineConfigurationResponse

Offline configuration.

provisioning_state str

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

source_server_name str

Name of the source sql server.

started_on str

Database migration start time.

migration_operation_id str

ID tracking current migration operation.

migration_service str

Resource Id of the Migration Service.

provisioning_error str

Error message for migration provisioning failure, if any.

scope str

Resource Id of the target resource (SQL VM or SQL Managed Instance).

source_database_name str

Name of the source database.

source_sql_connection SqlConnectionInformationResponse

Source SQL Server connection details.

table_list Sequence[str]

List of tables to copy.

target_database_collation str

Database collation to be used for the target database.

target_sql_connection SqlConnectionInformationResponse

Target SQL DB connection details.

endedOn String

Database migration end time.

migrationFailureError Property Map

Error details in case of migration failure.

migrationStatus String

Migration status.

migrationStatusDetails Property Map

Detailed migration status. Not included by default.

offlineConfiguration Property Map

Offline configuration.

provisioningState String

Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.

sourceServerName String

Name of the source sql server.

startedOn String

Database migration start time.

migrationOperationId String

ID tracking current migration operation.

migrationService String

Resource Id of the Migration Service.

provisioningError String

Error message for migration provisioning failure, if any.

scope String

Resource Id of the target resource (SQL VM or SQL Managed Instance).

sourceDatabaseName String

Name of the source database.

sourceSqlConnection Property Map

Source SQL Server connection details.

tableList List<String>

List of tables to copy.

targetDatabaseCollation String

Database collation to be used for the target database.

targetSqlConnection Property Map

Target SQL DB connection details.

ErrorInfoResponse

Code string

Error code.

Message string

Error message.

Code string

Error code.

Message string

Error message.

code String

Error code.

message String

Error message.

code string

Error code.

message string

Error message.

code str

Error code.

message str

Error message.

code String

Error code.

message String

Error message.

SqlConnectionInformationResponse

Authentication string

Authentication type.

DataSource string

Data source.

EncryptConnection bool

Whether to encrypt connection or not.

Password string

Password to connect to source SQL.

TrustServerCertificate bool

Whether to trust server certificate or not.

UserName string

User name to connect to source SQL.

Authentication string

Authentication type.

DataSource string

Data source.

EncryptConnection bool

Whether to encrypt connection or not.

Password string

Password to connect to source SQL.

TrustServerCertificate bool

Whether to trust server certificate or not.

UserName string

User name to connect to source SQL.

authentication String

Authentication type.

dataSource String

Data source.

encryptConnection Boolean

Whether to encrypt connection or not.

password String

Password to connect to source SQL.

trustServerCertificate Boolean

Whether to trust server certificate or not.

userName String

User name to connect to source SQL.

authentication string

Authentication type.

dataSource string

Data source.

encryptConnection boolean

Whether to encrypt connection or not.

password string

Password to connect to source SQL.

trustServerCertificate boolean

Whether to trust server certificate or not.

userName string

User name to connect to source SQL.

authentication str

Authentication type.

data_source str

Data source.

encrypt_connection bool

Whether to encrypt connection or not.

password str

Password to connect to source SQL.

trust_server_certificate bool

Whether to trust server certificate or not.

user_name str

User name to connect to source SQL.

authentication String

Authentication type.

dataSource String

Data source.

encryptConnection Boolean

Whether to encrypt connection or not.

password String

Password to connect to source SQL.

trustServerCertificate Boolean

Whether to trust server certificate or not.

userName String

User name to connect to source SQL.

SqlDbMigrationStatusDetailsResponse

ListOfCopyProgressDetails List<Pulumi.AzureNative.DataMigration.Inputs.CopyProgressDetailsResponse>

Details on progress of ADF copy activities.

MigrationState string

Current State of Migration.

SqlDataCopyErrors List<string>

Sql Data Copy errors, if any.

ListOfCopyProgressDetails []CopyProgressDetailsResponse

Details on progress of ADF copy activities.

MigrationState string

Current State of Migration.

SqlDataCopyErrors []string

Sql Data Copy errors, if any.

listOfCopyProgressDetails List<CopyProgressDetailsResponse>

Details on progress of ADF copy activities.

migrationState String

Current State of Migration.

sqlDataCopyErrors List<String>

Sql Data Copy errors, if any.

listOfCopyProgressDetails CopyProgressDetailsResponse[]

Details on progress of ADF copy activities.

migrationState string

Current State of Migration.

sqlDataCopyErrors string[]

Sql Data Copy errors, if any.

list_of_copy_progress_details Sequence[CopyProgressDetailsResponse]

Details on progress of ADF copy activities.

migration_state str

Current State of Migration.

sql_data_copy_errors Sequence[str]

Sql Data Copy errors, if any.

listOfCopyProgressDetails List<Property Map>

Details on progress of ADF copy activities.

migrationState String

Current State of Migration.

sqlDataCopyErrors List<String>

Sql Data Copy errors, if any.

SqlDbOfflineConfigurationResponse

Offline bool

Offline migration

Offline bool

Offline migration

offline Boolean

Offline migration

offline boolean

Offline migration

offline bool

Offline migration

offline Boolean

Offline migration

SystemDataResponse

Package Details

Repository
https://github.com/pulumi/pulumi-azure-native
License
Apache-2.0