azure-native.datamigration.getDatabaseMigrationsSqlDb
Explore with Pulumi AI
Retrieve the Database Migration resource.
Uses Azure REST API version 2023-07-15-preview.
Other available API versions: 2022-03-30-preview, 2025-03-15-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native datamigration [ApiVersion]
. See the version guide for details.
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)
public static Output<GetDatabaseMigrationsSqlDbResult> getDatabaseMigrationsSqlDb(GetDatabaseMigrationsSqlDbArgs args, InvokeOptions options)
fn::invoke:
function: azure-native:datamigration:getDatabaseMigrationsSqlDb
arguments:
# arguments dictionary
The following arguments are supported:
- Resource
Group Name This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- Target
Db Name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- Expand string
- Complete migration details be included in the response.
- Migration
Operation stringId - 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 This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- Target
Db Name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- Expand string
- Complete migration details be included in the response.
- Migration
Operation stringId - 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 This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- target
Db Name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- expand String
- Complete migration details be included in the response.
- migration
Operation StringId - 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 This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- target
Db Name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- expand string
- Complete migration details be included in the response.
- migration
Operation stringId - 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 This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- target_
db_ name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- expand str
- Complete migration details be included in the response.
- migration_
operation_ strid - 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 This property is required. Changes to this property will trigger replacement.
- 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 This property is required. Changes to this property will trigger replacement.
- target
Db Name This property is required. Changes to this property will trigger replacement.
- The name of the target database.
- expand String
- Complete migration details be included in the response.
- migration
Operation StringId - 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:
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Name string
- Properties
Pulumi.
Azure Native. Data Migration. Outputs. Database Migration Properties Sql Db Response - Database Migration Resource properties for SQL database.
- System
Data Pulumi.Azure Native. Data Migration. Outputs. System Data Response - Metadata pertaining to creation and last modification of the resource.
- Type string
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Name string
- Properties
Database
Migration Properties Sql Db Response - Database Migration Resource properties for SQL database.
- System
Data SystemData Response - Metadata pertaining to creation and last modification of the resource.
- Type string
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- name String
- properties
Database
Migration Properties Sql Db Response - Database Migration Resource properties for SQL database.
- system
Data SystemData Response - Metadata pertaining to creation and last modification of the resource.
- type String
- azure
Api stringVersion - The Azure API version of the resource.
- id string
- name string
- properties
Database
Migration Properties Sql Db Response - Database Migration Resource properties for SQL database.
- system
Data SystemData Response - Metadata pertaining to creation and last modification of the resource.
- type string
- azure_
api_ strversion - The Azure API version of the resource.
- id str
- name str
- properties
Database
Migration Properties Sql Db Response - Database Migration Resource properties for SQL database.
- system_
data SystemData Response - Metadata pertaining to creation and last modification of the resource.
- type str
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- name String
- properties Property Map
- Database Migration Resource properties for SQL database.
- system
Data Property Map - Metadata pertaining to creation and last modification of the resource.
- type String
Supporting Types
CopyProgressDetailsResponse
- Copy
Duration This property is required. int - Copy Duration in seconds
- Copy
Start This property is required. string - Copy Start
- Copy
Throughput This property is required. double - Copy throughput in KBps
- Data
Read This property is required. double - Bytes read
- Data
Written This property is required. double - Bytes written
- Parallel
Copy Type This property is required. string - Type of parallel copy (Dynamic range, Physical partition, none).
- Rows
Copied This property is required. double - Rows Copied
- Rows
Read This property is required. double - Rows read
- Status
This property is required. string - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- Table
Name This property is required. string - Table Name
- Used
Parallel Copies This property is required. int - The degree of parallelization.
- Copy
Duration This property is required. int - Copy Duration in seconds
- Copy
Start This property is required. string - Copy Start
- Copy
Throughput This property is required. float64 - Copy throughput in KBps
- Data
Read This property is required. float64 - Bytes read
- Data
Written This property is required. float64 - Bytes written
- Parallel
Copy Type This property is required. string - Type of parallel copy (Dynamic range, Physical partition, none).
- Rows
Copied This property is required. float64 - Rows Copied
- Rows
Read This property is required. float64 - Rows read
- Status
This property is required. string - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- Table
Name This property is required. string - Table Name
- Used
Parallel Copies This property is required. int - The degree of parallelization.
- copy
Duration This property is required. Integer - Copy Duration in seconds
- copy
Start This property is required. String - Copy Start
- copy
Throughput This property is required. Double - Copy throughput in KBps
- data
Read This property is required. Double - Bytes read
- data
Written This property is required. Double - Bytes written
- parallel
Copy Type This property is required. String - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied This property is required. Double - Rows Copied
- rows
Read This property is required. Double - Rows read
- status
This property is required. String - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name This property is required. String - Table Name
- used
Parallel Copies This property is required. Integer - The degree of parallelization.
- copy
Duration This property is required. number - Copy Duration in seconds
- copy
Start This property is required. string - Copy Start
- copy
Throughput This property is required. number - Copy throughput in KBps
- data
Read This property is required. number - Bytes read
- data
Written This property is required. number - Bytes written
- parallel
Copy Type This property is required. string - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied This property is required. number - Rows Copied
- rows
Read This property is required. number - Rows read
- status
This property is required. string - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name This property is required. string - Table Name
- used
Parallel Copies This property is required. number - The degree of parallelization.
- copy_
duration This property is required. int - Copy Duration in seconds
- copy_
start This property is required. str - Copy Start
- copy_
throughput This property is required. float - Copy throughput in KBps
- data_
read This property is required. float - Bytes read
- data_
written This property is required. float - Bytes written
- parallel_
copy_ type This property is required. str - Type of parallel copy (Dynamic range, Physical partition, none).
- rows_
copied This property is required. float - Rows Copied
- rows_
read This property is required. float - Rows read
- status
This property is required. str - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table_
name This property is required. str - Table Name
- used_
parallel_ copies This property is required. int - The degree of parallelization.
- copy
Duration This property is required. Number - Copy Duration in seconds
- copy
Start This property is required. String - Copy Start
- copy
Throughput This property is required. Number - Copy throughput in KBps
- data
Read This property is required. Number - Bytes read
- data
Written This property is required. Number - Bytes written
- parallel
Copy Type This property is required. String - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied This property is required. Number - Rows Copied
- rows
Read This property is required. Number - Rows read
- status
This property is required. String - Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name This property is required. String - Table Name
- used
Parallel Copies This property is required. Number - The degree of parallelization.
DatabaseMigrationPropertiesSqlDbResponse
- Ended
On This property is required. string - Database migration end time.
- Migration
Failure Error This property is required. Pulumi.Azure Native. Data Migration. Inputs. Error Info Response - Error details in case of migration failure.
- Migration
Status This property is required. string - Migration status.
- Migration
Status Details This property is required. Pulumi.Azure Native. Data Migration. Inputs. Sql Db Migration Status Details Response - Detailed migration status. Not included by default.
- Offline
Configuration This property is required. Pulumi.Azure Native. Data Migration. Inputs. Sql Db Offline Configuration Response - Offline configuration.
- Provisioning
State This property is required. string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- Source
Server Name This property is required. string - Name of the source sql server.
- Started
On This property is required. string - Database migration start time.
- Migration
Operation stringId - ID for current migration operation.
- Migration
Service string - Resource Id of the Migration Service.
- Provisioning
Error string - Error message for migration provisioning failure, if any.
- Scope string
- Resource Id of the target resource.
- Source
Database stringName - Name of the source database.
- Source
Sql Pulumi.Connection Azure Native. Data Migration. Inputs. Sql Connection Information Response - Source SQL Server connection details.
- Table
List List<string> - List of tables to copy.
- Target
Database stringCollation - Database collation to be used for the target database.
- Target
Sql Pulumi.Connection Azure Native. Data Migration. Inputs. Sql Connection Information Response - Target SQL DB connection details.
- Ended
On This property is required. string - Database migration end time.
- Migration
Failure Error This property is required. ErrorInfo Response - Error details in case of migration failure.
- Migration
Status This property is required. string - Migration status.
- Migration
Status Details This property is required. SqlDb Migration Status Details Response - Detailed migration status. Not included by default.
- Offline
Configuration This property is required. SqlDb Offline Configuration Response - Offline configuration.
- Provisioning
State This property is required. string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- Source
Server Name This property is required. string - Name of the source sql server.
- Started
On This property is required. string - Database migration start time.
- Migration
Operation stringId - ID for current migration operation.
- Migration
Service string - Resource Id of the Migration Service.
- Provisioning
Error string - Error message for migration provisioning failure, if any.
- Scope string
- Resource Id of the target resource.
- Source
Database stringName - Name of the source database.
- Source
Sql SqlConnection Connection Information Response - Source SQL Server connection details.
- Table
List []string - List of tables to copy.
- Target
Database stringCollation - Database collation to be used for the target database.
- Target
Sql SqlConnection Connection Information Response - Target SQL DB connection details.
- ended
On This property is required. String - Database migration end time.
- migration
Failure Error This property is required. ErrorInfo Response - Error details in case of migration failure.
- migration
Status This property is required. String - Migration status.
- migration
Status Details This property is required. SqlDb Migration Status Details Response - Detailed migration status. Not included by default.
- offline
Configuration This property is required. SqlDb Offline Configuration Response - Offline configuration.
- provisioning
State This property is required. String - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server Name This property is required. String - Name of the source sql server.
- started
On This property is required. String - Database migration start time.
- migration
Operation StringId - ID for current migration operation.
- migration
Service String - Resource Id of the Migration Service.
- provisioning
Error String - Error message for migration provisioning failure, if any.
- scope String
- Resource Id of the target resource.
- source
Database StringName - Name of the source database.
- source
Sql SqlConnection Connection Information Response - Source SQL Server connection details.
- table
List List<String> - List of tables to copy.
- target
Database StringCollation - Database collation to be used for the target database.
- target
Sql SqlConnection Connection Information Response - Target SQL DB connection details.
- ended
On This property is required. string - Database migration end time.
- migration
Failure Error This property is required. ErrorInfo Response - Error details in case of migration failure.
- migration
Status This property is required. string - Migration status.
- migration
Status Details This property is required. SqlDb Migration Status Details Response - Detailed migration status. Not included by default.
- offline
Configuration This property is required. SqlDb Offline Configuration Response - Offline configuration.
- provisioning
State This property is required. string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server Name This property is required. string - Name of the source sql server.
- started
On This property is required. string - Database migration start time.
- migration
Operation stringId - ID for current migration operation.
- migration
Service string - Resource Id of the Migration Service.
- provisioning
Error string - Error message for migration provisioning failure, if any.
- scope string
- Resource Id of the target resource.
- source
Database stringName - Name of the source database.
- source
Sql SqlConnection Connection Information Response - Source SQL Server connection details.
- table
List string[] - List of tables to copy.
- target
Database stringCollation - Database collation to be used for the target database.
- target
Sql SqlConnection Connection Information Response - Target SQL DB connection details.
- ended_
on This property is required. str - Database migration end time.
- migration_
failure_ error This property is required. ErrorInfo Response - Error details in case of migration failure.
- migration_
status This property is required. str - Migration status.
- migration_
status_ details This property is required. SqlDb Migration Status Details Response - Detailed migration status. Not included by default.
- offline_
configuration This property is required. SqlDb Offline Configuration Response - Offline configuration.
- provisioning_
state This property is required. str - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source_
server_ name This property is required. str - Name of the source sql server.
- started_
on This property is required. str - Database migration start time.
- migration_
operation_ strid - ID for 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.
- source_
database_ strname - Name of the source database.
- source_
sql_ Sqlconnection Connection Information Response - Source SQL Server connection details.
- table_
list Sequence[str] - List of tables to copy.
- target_
database_ strcollation - Database collation to be used for the target database.
- target_
sql_ Sqlconnection Connection Information Response - Target SQL DB connection details.
- ended
On This property is required. String - Database migration end time.
- migration
Failure Error This property is required. Property Map - Error details in case of migration failure.
- migration
Status This property is required. String - Migration status.
- migration
Status Details This property is required. Property Map - Detailed migration status. Not included by default.
- offline
Configuration This property is required. Property Map - Offline configuration.
- provisioning
State This property is required. String - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server Name This property is required. String - Name of the source sql server.
- started
On This property is required. String - Database migration start time.
- migration
Operation StringId - ID for current migration operation.
- migration
Service String - Resource Id of the Migration Service.
- provisioning
Error String - Error message for migration provisioning failure, if any.
- scope String
- Resource Id of the target resource.
- source
Database StringName - Name of the source database.
- source
Sql Property MapConnection - Source SQL Server connection details.
- table
List List<String> - List of tables to copy.
- target
Database StringCollation - Database collation to be used for the target database.
- target
Sql Property MapConnection - Target SQL DB connection details.
ErrorInfoResponse
SqlConnectionInformationResponse
- Authentication string
- Authentication type.
- Data
Source string - Data source.
- Encrypt
Connection bool - Whether to encrypt connection or not.
- Password string
- Password to connect to source SQL.
- Trust
Server boolCertificate - Whether to trust server certificate or not.
- User
Name string - User name to connect to source SQL.
- Authentication string
- Authentication type.
- Data
Source string - Data source.
- Encrypt
Connection bool - Whether to encrypt connection or not.
- Password string
- Password to connect to source SQL.
- Trust
Server boolCertificate - Whether to trust server certificate or not.
- User
Name string - User name to connect to source SQL.
- authentication String
- Authentication type.
- data
Source String - Data source.
- encrypt
Connection Boolean - Whether to encrypt connection or not.
- password String
- Password to connect to source SQL.
- trust
Server BooleanCertificate - Whether to trust server certificate or not.
- user
Name String - User name to connect to source SQL.
- authentication string
- Authentication type.
- data
Source string - Data source.
- encrypt
Connection boolean - Whether to encrypt connection or not.
- password string
- Password to connect to source SQL.
- trust
Server booleanCertificate - Whether to trust server certificate or not.
- user
Name 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_ boolcertificate - Whether to trust server certificate or not.
- user_
name str - User name to connect to source SQL.
- authentication String
- Authentication type.
- data
Source String - Data source.
- encrypt
Connection Boolean - Whether to encrypt connection or not.
- password String
- Password to connect to source SQL.
- trust
Server BooleanCertificate - Whether to trust server certificate or not.
- user
Name String - User name to connect to source SQL.
SqlDbMigrationStatusDetailsResponse
- List
Of Copy Progress Details This property is required. List<Pulumi.Azure Native. Data Migration. Inputs. Copy Progress Details Response> - Details on progress of ADF copy activities.
- Migration
State This property is required. string - Current State of Migration.
- Sql
Data Copy Errors This property is required. List<string> - Sql Data Copy errors, if any.
- List
Of Copy Progress Details This property is required. []CopyProgress Details Response - Details on progress of ADF copy activities.
- Migration
State This property is required. string - Current State of Migration.
- Sql
Data Copy Errors This property is required. []string - Sql Data Copy errors, if any.
- list
Of Copy Progress Details This property is required. List<CopyProgress Details Response> - Details on progress of ADF copy activities.
- migration
State This property is required. String - Current State of Migration.
- sql
Data Copy Errors This property is required. List<String> - Sql Data Copy errors, if any.
- list
Of Copy Progress Details This property is required. CopyProgress Details Response[] - Details on progress of ADF copy activities.
- migration
State This property is required. string - Current State of Migration.
- sql
Data Copy Errors This property is required. string[] - Sql Data Copy errors, if any.
- list_
of_ copy_ progress_ details This property is required. Sequence[CopyProgress Details Response] - Details on progress of ADF copy activities.
- migration_
state This property is required. str - Current State of Migration.
- sql_
data_ copy_ errors This property is required. Sequence[str] - Sql Data Copy errors, if any.
- list
Of Copy Progress Details This property is required. List<Property Map> - Details on progress of ADF copy activities.
- migration
State This property is required. String - Current State of Migration.
- sql
Data Copy Errors This property is required. List<String> - Sql Data Copy errors, if any.
SqlDbOfflineConfigurationResponse
- Offline
This property is required. bool - Offline migration
- Offline
This property is required. bool - Offline migration
- offline
This property is required. Boolean - Offline migration
- offline
This property is required. boolean - Offline migration
- offline
This property is required. bool - Offline migration
- offline
This property is required. Boolean - Offline migration
SystemDataResponse
- Created
At string - Created
By string - Created
By stringType - Last
Modified stringAt - Last
Modified stringBy - Last
Modified stringBy Type
- Created
At string - Created
By string - Created
By stringType - Last
Modified stringAt - Last
Modified stringBy - Last
Modified stringBy Type
- created
At String - created
By String - created
By StringType - last
Modified StringAt - last
Modified StringBy - last
Modified StringBy Type
- created
At string - created
By string - created
By stringType - last
Modified stringAt - last
Modified stringBy - last
Modified stringBy Type
- created_
at str - created_
by str - created_
by_ strtype - last_
modified_ strat - last_
modified_ strby - last_
modified_ strby_ type
- created
At String - created
By String - created
By StringType - last
Modified StringAt - last
Modified StringBy - last
Modified StringBy Type
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0