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.77.0 published on Thursday, Dec 12, 2024 by Pulumi
azure-native.datamigration.getDatabaseMigrationsSqlDb
Explore with Pulumi AI
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.77.0 published on Thursday, Dec 12, 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:
- Resource
Group stringName - 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 stringInstance Name - Target
Db stringName - 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 stringName - 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 stringInstance Name - Target
Db stringName - 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 StringName - 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 StringInstance Name - target
Db StringName - 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 stringName - 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 stringInstance Name - target
Db stringName - 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_ strname - 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_ strinstance_ name - target_
db_ strname - 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 StringName - 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 StringInstance Name - target
Db StringName - 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:
- 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
- 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
- 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
- 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
- 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
- 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 int - Copy Duration in seconds
- Copy
Start string - Copy Start
- Copy
Throughput double - Copy throughput in KBps
- Data
Read double - Bytes read
- Data
Written double - Bytes written
- Parallel
Copy stringType - Type of parallel copy (Dynamic range, Physical partition, none).
- Rows
Copied double - Rows Copied
- Rows
Read double - Rows read
- Status string
- Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- Table
Name string - Table Name
- Used
Parallel intCopies - The degree of parallelization.
- Copy
Duration int - Copy Duration in seconds
- Copy
Start string - Copy Start
- Copy
Throughput float64 - Copy throughput in KBps
- Data
Read float64 - Bytes read
- Data
Written float64 - Bytes written
- Parallel
Copy stringType - Type of parallel copy (Dynamic range, Physical partition, none).
- Rows
Copied float64 - Rows Copied
- Rows
Read float64 - Rows read
- Status string
- Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- Table
Name string - Table Name
- Used
Parallel intCopies - The degree of parallelization.
- copy
Duration Integer - Copy Duration in seconds
- copy
Start String - Copy Start
- copy
Throughput Double - Copy throughput in KBps
- data
Read Double - Bytes read
- data
Written Double - Bytes written
- parallel
Copy StringType - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied Double - Rows Copied
- rows
Read Double - Rows read
- status String
- Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name String - Table Name
- used
Parallel IntegerCopies - The degree of parallelization.
- copy
Duration number - Copy Duration in seconds
- copy
Start string - Copy Start
- copy
Throughput number - Copy throughput in KBps
- data
Read number - Bytes read
- data
Written number - Bytes written
- parallel
Copy stringType - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied number - Rows Copied
- rows
Read number - Rows read
- status string
- Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name string - Table Name
- used
Parallel numberCopies - 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_ strtype - 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_ intcopies - The degree of parallelization.
- copy
Duration Number - Copy Duration in seconds
- copy
Start String - Copy Start
- copy
Throughput Number - Copy throughput in KBps
- data
Read Number - Bytes read
- data
Written Number - Bytes written
- parallel
Copy StringType - Type of parallel copy (Dynamic range, Physical partition, none).
- rows
Copied Number - Rows Copied
- rows
Read Number - Rows read
- status String
- Status of the Copy activity (InProgress, Succeeded, Failed, Canceled).
- table
Name String - Table Name
- used
Parallel NumberCopies - The degree of parallelization.
DatabaseMigrationPropertiesSqlDbResponse
- Ended
On string - Database migration end time.
- Migration
Failure Pulumi.Error Azure Native. Data Migration. Inputs. Error Info Response - Error details in case of migration failure.
- Migration
Status string - Migration status.
- Migration
Status Pulumi.Details Azure Native. Data Migration. Inputs. Sql Db Migration Status Details Response - Detailed migration status. Not included by default.
- Offline
Configuration Pulumi.Azure Native. Data Migration. Inputs. Sql Db Offline Configuration Response - Offline configuration.
- Provisioning
State string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- Source
Server stringName - Name of the source sql server.
- Started
On string - Database migration start time.
- Migration
Operation stringId - ID tracking 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 (SQL VM or SQL Managed Instance).
- 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 string - Database migration end time.
- Migration
Failure ErrorError Info Response - Error details in case of migration failure.
- Migration
Status string - Migration status.
- Migration
Status SqlDetails Db Migration Status Details Response - Detailed migration status. Not included by default.
- Offline
Configuration SqlDb Offline Configuration Response - Offline configuration.
- Provisioning
State string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- Source
Server stringName - Name of the source sql server.
- Started
On string - Database migration start time.
- Migration
Operation stringId - ID tracking 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 (SQL VM or SQL Managed Instance).
- 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 String - Database migration end time.
- migration
Failure ErrorError Info Response - Error details in case of migration failure.
- migration
Status String - Migration status.
- migration
Status SqlDetails Db Migration Status Details Response - Detailed migration status. Not included by default.
- offline
Configuration SqlDb Offline Configuration Response - Offline configuration.
- provisioning
State String - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server StringName - Name of the source sql server.
- started
On String - Database migration start time.
- migration
Operation StringId - ID tracking 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 (SQL VM or SQL Managed Instance).
- 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 string - Database migration end time.
- migration
Failure ErrorError Info Response - Error details in case of migration failure.
- migration
Status string - Migration status.
- migration
Status SqlDetails Db Migration Status Details Response - Detailed migration status. Not included by default.
- offline
Configuration SqlDb Offline Configuration Response - Offline configuration.
- provisioning
State string - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server stringName - Name of the source sql server.
- started
On string - Database migration start time.
- migration
Operation stringId - ID tracking 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 (SQL VM or SQL Managed Instance).
- 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 str - Database migration end time.
- migration_
failure_ Errorerror Info Response - Error details in case of migration failure.
- migration_
status str - Migration status.
- migration_
status_ Sqldetails Db Migration Status Details Response - Detailed migration status. Not included by default.
- offline_
configuration SqlDb Offline Configuration Response - Offline configuration.
- provisioning_
state str - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source_
server_ strname - Name of the source sql server.
- started_
on str - Database migration start time.
- migration_
operation_ strid - 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_ 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 String - Database migration end time.
- migration
Failure Property MapError - Error details in case of migration failure.
- migration
Status String - Migration status.
- migration
Status Property MapDetails - Detailed migration status. Not included by default.
- offline
Configuration Property Map - Offline configuration.
- provisioning
State String - Provisioning State of migration. ProvisioningState as Succeeded implies that validations have been performed and migration has started.
- source
Server StringName - Name of the source sql server.
- started
On String - Database migration start time.
- migration
Operation StringId - ID tracking 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 (SQL VM or SQL Managed Instance).
- 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 List<Pulumi.Copy Progress Details Azure Native. Data Migration. Inputs. Copy Progress Details Response> - Details on progress of ADF copy activities.
- Migration
State string - Current State of Migration.
- Sql
Data List<string>Copy Errors - Sql Data Copy errors, if any.
- List
Of []CopyCopy Progress Details Progress Details Response - Details on progress of ADF copy activities.
- Migration
State string - Current State of Migration.
- Sql
Data []stringCopy Errors - Sql Data Copy errors, if any.
- list
Of List<CopyCopy Progress Details Progress Details Response> - Details on progress of ADF copy activities.
- migration
State String - Current State of Migration.
- sql
Data List<String>Copy Errors - Sql Data Copy errors, if any.
- list
Of CopyCopy Progress Details Progress Details Response[] - Details on progress of ADF copy activities.
- migration
State string - Current State of Migration.
- sql
Data string[]Copy Errors - Sql Data Copy errors, if any.
- list_
of_ Sequence[Copycopy_ progress_ details Progress Details Response] - Details on progress of ADF copy activities.
- migration_
state str - Current State of Migration.
- sql_
data_ Sequence[str]copy_ errors - Sql Data Copy errors, if any.
- list
Of List<Property Map>Copy Progress Details - Details on progress of ADF copy activities.
- migration
State String - Current State of Migration.
- sql
Data List<String>Copy Errors - 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
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
- created
At string - The timestamp of resource creation (UTC).
- created
By string - The identity that created the resource.
- created
By stringType - The type of identity that created the resource.
- last
Modified stringAt - The timestamp of resource last modification (UTC)
- last
Modified stringBy - The identity that last modified the resource.
- last
Modified stringBy Type - 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_ strtype - The type of identity that created the resource.
- last_
modified_ strat - The timestamp of resource last modification (UTC)
- last_
modified_ strby - The identity that last modified the resource.
- last_
modified_ strby_ type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0
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.77.0 published on Thursday, Dec 12, 2024 by Pulumi