Azure Native v1.103.0, Jun 2 23

Azure Native v1.103.0 published on Friday, Jun 2, 2023 by Pulumi

azure-native.datamigration.getDatabaseMigrationsSqlDb

Explore with Pulumi AI

Azure Native v1.103.0 published on Friday, Jun 2, 2023 by Pulumi

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.