1. Packages
  2. Azure Native
  3. API Docs
  4. datamigration
  5. getDatabaseMigrationsSqlDb
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.19.0 published on Tuesday, Nov 21, 2023 by Pulumi

azure-native.datamigration.getDatabaseMigrationsSqlDb

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.19.0 published on Tuesday, Nov 21, 2023 by Pulumi

    Retrieve the Database Migration resource. Azure REST 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

    CreatedAt string

    The timestamp of resource creation (UTC).

    CreatedBy string

    The identity that created the resource.

    CreatedByType string

    The type of identity that created the resource.

    LastModifiedAt string

    The timestamp of resource last modification (UTC)

    LastModifiedBy string

    The identity that last modified the resource.

    LastModifiedByType string

    The type of identity that last modified the resource.

    CreatedAt string

    The timestamp of resource creation (UTC).

    CreatedBy string

    The identity that created the resource.

    CreatedByType string

    The type of identity that created the resource.

    LastModifiedAt string

    The timestamp of resource last modification (UTC)

    LastModifiedBy string

    The identity that last modified the resource.

    LastModifiedByType string

    The type of identity that last modified the resource.

    createdAt String

    The timestamp of resource creation (UTC).

    createdBy String

    The identity that created the resource.

    createdByType String

    The type of identity that created the resource.

    lastModifiedAt String

    The timestamp of resource last modification (UTC)

    lastModifiedBy String

    The identity that last modified the resource.

    lastModifiedByType String

    The type of identity that last modified the resource.

    createdAt string

    The timestamp of resource creation (UTC).

    createdBy string

    The identity that created the resource.

    createdByType string

    The type of identity that created the resource.

    lastModifiedAt string

    The timestamp of resource last modification (UTC)

    lastModifiedBy string

    The identity that last modified the resource.

    lastModifiedByType string

    The type of identity that last modified the resource.

    created_at str

    The timestamp of resource creation (UTC).

    created_by str

    The identity that created the resource.

    created_by_type str

    The type of identity that created the resource.

    last_modified_at str

    The timestamp of resource last modification (UTC)

    last_modified_by str

    The identity that last modified the resource.

    last_modified_by_type str

    The type of identity that last modified the resource.

    createdAt String

    The timestamp of resource creation (UTC).

    createdBy String

    The identity that created the resource.

    createdByType String

    The type of identity that created the resource.

    lastModifiedAt String

    The timestamp of resource last modification (UTC)

    lastModifiedBy String

    The identity that last modified the resource.

    lastModifiedByType String

    The type of identity that last modified the resource.

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.19.0 published on Tuesday, Nov 21, 2023 by Pulumi