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.34.0 published on Thursday, Mar 28, 2024 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.34.0 published on Thursday, Mar 28, 2024 by Pulumi

    Retrieve the Database Migration resource. Azure REST API version: 2022-03-30-preview.

    Other available API versions: 2023-07-15-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.34.0 published on Thursday, Mar 28, 2024 by Pulumi