Azure Native

Pulumi Official
Package maintained by Pulumi
v1.68.2 published on Tuesday, Aug 16, 2022 by Pulumi

DatabaseMigrationsSqlDb

Database Migration Resource for SQL Database. API Version: 2022-03-30-preview.

Example Usage

Create or Update Database Migration resource with Maximum parameters.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var databaseMigrationsSqlDb = new AzureNative.DataMigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", new()
    {
        Properties = new AzureNative.DataMigration.Inputs.DatabaseMigrationPropertiesSqlDbArgs
        {
            Kind = "SqlDb",
            MigrationService = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
            Scope = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
            SourceDatabaseName = "aaa",
            SourceSqlConnection = new AzureNative.DataMigration.Inputs.SqlConnectionInformationArgs
            {
                Authentication = "WindowsAuthentication",
                DataSource = "aaa",
                EncryptConnection = true,
                Password = "placeholder",
                TrustServerCertificate = true,
                UserName = "bbb",
            },
            TableList = new[]
            {
                "[Schema1].[TableName1]",
                "[Schema2].[TableName2]",
            },
            TargetSqlConnection = new AzureNative.DataMigration.Inputs.SqlConnectionInformationArgs
            {
                Authentication = "SqlAuthentication",
                DataSource = "sqldbinstance",
                EncryptConnection = true,
                Password = "placeholder",
                TrustServerCertificate = true,
                UserName = "bbb",
            },
        },
        ResourceGroupName = "testrg",
        SqlDbInstanceName = "sqldbinstance",
        TargetDbName = "db1",
    });

});

Coming soon!

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.datamigration.DatabaseMigrationsSqlDb;
import com.pulumi.azurenative.datamigration.DatabaseMigrationsSqlDbArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var databaseMigrationsSqlDb = new DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", DatabaseMigrationsSqlDbArgs.builder()        
            .properties(Map.ofEntries(
                Map.entry("kind", "SqlDb"),
                Map.entry("migrationService", "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent"),
                Map.entry("scope", "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance"),
                Map.entry("sourceDatabaseName", "aaa"),
                Map.entry("sourceSqlConnection", Map.ofEntries(
                    Map.entry("authentication", "WindowsAuthentication"),
                    Map.entry("dataSource", "aaa"),
                    Map.entry("encryptConnection", true),
                    Map.entry("password", "placeholder"),
                    Map.entry("trustServerCertificate", true),
                    Map.entry("userName", "bbb")
                )),
                Map.entry("tableList",                 
                    "[Schema1].[TableName1]",
                    "[Schema2].[TableName2]"),
                Map.entry("targetSqlConnection", Map.ofEntries(
                    Map.entry("authentication", "SqlAuthentication"),
                    Map.entry("dataSource", "sqldbinstance"),
                    Map.entry("encryptConnection", true),
                    Map.entry("password", "placeholder"),
                    Map.entry("trustServerCertificate", true),
                    Map.entry("userName", "bbb")
                ))
            ))
            .resourceGroupName("testrg")
            .sqlDbInstanceName("sqldbinstance")
            .targetDbName("db1")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

database_migrations_sql_db = azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb",
    properties={
        "kind": "SqlDb",
        "migrationService": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
        "scope": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
        "sourceDatabaseName": "aaa",
        "sourceSqlConnection": azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="WindowsAuthentication",
            data_source="aaa",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
        "tableList": [
            "[Schema1].[TableName1]",
            "[Schema2].[TableName2]",
        ],
        "targetSqlConnection": azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="SqlAuthentication",
            data_source="sqldbinstance",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
    },
    resource_group_name="testrg",
    sql_db_instance_name="sqldbinstance",
    target_db_name="db1")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const databaseMigrationsSqlDb = new azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", {
    properties: {
        kind: "SqlDb",
        migrationService: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
        scope: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
        sourceDatabaseName: "aaa",
        sourceSqlConnection: {
            authentication: "WindowsAuthentication",
            dataSource: "aaa",
            encryptConnection: true,
            password: "placeholder",
            trustServerCertificate: true,
            userName: "bbb",
        },
        tableList: [
            "[Schema1].[TableName1]",
            "[Schema2].[TableName2]",
        ],
        targetSqlConnection: {
            authentication: "SqlAuthentication",
            dataSource: "sqldbinstance",
            encryptConnection: true,
            password: "placeholder",
            trustServerCertificate: true,
            userName: "bbb",
        },
    },
    resourceGroupName: "testrg",
    sqlDbInstanceName: "sqldbinstance",
    targetDbName: "db1",
});
resources:
  databaseMigrationsSqlDb:
    type: azure-native:datamigration:DatabaseMigrationsSqlDb
    properties:
      properties:
        kind: SqlDb
        migrationService: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent
        scope: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance
        sourceDatabaseName: aaa
        sourceSqlConnection:
          authentication: WindowsAuthentication
          dataSource: aaa
          encryptConnection: true
          password: placeholder
          trustServerCertificate: true
          userName: bbb
        tableList:
          - '[Schema1].[TableName1]'
          - '[Schema2].[TableName2]'
        targetSqlConnection:
          authentication: SqlAuthentication
          dataSource: sqldbinstance
          encryptConnection: true
          password: placeholder
          trustServerCertificate: true
          userName: bbb
      resourceGroupName: testrg
      sqlDbInstanceName: sqldbinstance
      targetDbName: db1

Create or Update Database Migration resource with Minimum parameters.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var databaseMigrationsSqlDb = new AzureNative.DataMigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", new()
    {
        Properties = new AzureNative.DataMigration.Inputs.DatabaseMigrationPropertiesSqlDbArgs
        {
            Kind = "SqlDb",
            MigrationService = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
            Scope = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
            SourceDatabaseName = "aaa",
            SourceSqlConnection = new AzureNative.DataMigration.Inputs.SqlConnectionInformationArgs
            {
                Authentication = "WindowsAuthentication",
                DataSource = "aaa",
                EncryptConnection = true,
                Password = "placeholder",
                TrustServerCertificate = true,
                UserName = "bbb",
            },
            TargetSqlConnection = new AzureNative.DataMigration.Inputs.SqlConnectionInformationArgs
            {
                Authentication = "SqlAuthentication",
                DataSource = "sqldbinstance",
                EncryptConnection = true,
                Password = "placeholder",
                TrustServerCertificate = true,
                UserName = "bbb",
            },
        },
        ResourceGroupName = "testrg",
        SqlDbInstanceName = "sqldbinstance",
        TargetDbName = "db1",
    });

});

Coming soon!

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.datamigration.DatabaseMigrationsSqlDb;
import com.pulumi.azurenative.datamigration.DatabaseMigrationsSqlDbArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var databaseMigrationsSqlDb = new DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", DatabaseMigrationsSqlDbArgs.builder()        
            .properties(Map.ofEntries(
                Map.entry("kind", "SqlDb"),
                Map.entry("migrationService", "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent"),
                Map.entry("scope", "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance"),
                Map.entry("sourceDatabaseName", "aaa"),
                Map.entry("sourceSqlConnection", Map.ofEntries(
                    Map.entry("authentication", "WindowsAuthentication"),
                    Map.entry("dataSource", "aaa"),
                    Map.entry("encryptConnection", true),
                    Map.entry("password", "placeholder"),
                    Map.entry("trustServerCertificate", true),
                    Map.entry("userName", "bbb")
                )),
                Map.entry("targetSqlConnection", Map.ofEntries(
                    Map.entry("authentication", "SqlAuthentication"),
                    Map.entry("dataSource", "sqldbinstance"),
                    Map.entry("encryptConnection", true),
                    Map.entry("password", "placeholder"),
                    Map.entry("trustServerCertificate", true),
                    Map.entry("userName", "bbb")
                ))
            ))
            .resourceGroupName("testrg")
            .sqlDbInstanceName("sqldbinstance")
            .targetDbName("db1")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

database_migrations_sql_db = azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb",
    properties={
        "kind": "SqlDb",
        "migrationService": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
        "scope": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
        "sourceDatabaseName": "aaa",
        "sourceSqlConnection": azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="WindowsAuthentication",
            data_source="aaa",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
        "targetSqlConnection": azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="SqlAuthentication",
            data_source="sqldbinstance",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
    },
    resource_group_name="testrg",
    sql_db_instance_name="sqldbinstance",
    target_db_name="db1")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const databaseMigrationsSqlDb = new azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDb", {
    properties: {
        kind: "SqlDb",
        migrationService: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent",
        scope: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance",
        sourceDatabaseName: "aaa",
        sourceSqlConnection: {
            authentication: "WindowsAuthentication",
            dataSource: "aaa",
            encryptConnection: true,
            password: "placeholder",
            trustServerCertificate: true,
            userName: "bbb",
        },
        targetSqlConnection: {
            authentication: "SqlAuthentication",
            dataSource: "sqldbinstance",
            encryptConnection: true,
            password: "placeholder",
            trustServerCertificate: true,
            userName: "bbb",
        },
    },
    resourceGroupName: "testrg",
    sqlDbInstanceName: "sqldbinstance",
    targetDbName: "db1",
});
resources:
  databaseMigrationsSqlDb:
    type: azure-native:datamigration:DatabaseMigrationsSqlDb
    properties:
      properties:
        kind: SqlDb
        migrationService: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent
        scope: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance
        sourceDatabaseName: aaa
        sourceSqlConnection:
          authentication: WindowsAuthentication
          dataSource: aaa
          encryptConnection: true
          password: placeholder
          trustServerCertificate: true
          userName: bbb
        targetSqlConnection:
          authentication: SqlAuthentication
          dataSource: sqldbinstance
          encryptConnection: true
          password: placeholder
          trustServerCertificate: true
          userName: bbb
      resourceGroupName: testrg
      sqlDbInstanceName: sqldbinstance
      targetDbName: db1

Create a DatabaseMigrationsSqlDb Resource

new DatabaseMigrationsSqlDb(name: string, args: DatabaseMigrationsSqlDbArgs, opts?: CustomResourceOptions);
@overload
def DatabaseMigrationsSqlDb(resource_name: str,
                            opts: Optional[ResourceOptions] = None,
                            properties: Optional[DatabaseMigrationPropertiesSqlDbArgs] = None,
                            resource_group_name: Optional[str] = None,
                            sql_db_instance_name: Optional[str] = None,
                            target_db_name: Optional[str] = None)
@overload
def DatabaseMigrationsSqlDb(resource_name: str,
                            args: DatabaseMigrationsSqlDbArgs,
                            opts: Optional[ResourceOptions] = None)
func NewDatabaseMigrationsSqlDb(ctx *Context, name string, args DatabaseMigrationsSqlDbArgs, opts ...ResourceOption) (*DatabaseMigrationsSqlDb, error)
public DatabaseMigrationsSqlDb(string name, DatabaseMigrationsSqlDbArgs args, CustomResourceOptions? opts = null)
public DatabaseMigrationsSqlDb(String name, DatabaseMigrationsSqlDbArgs args)
public DatabaseMigrationsSqlDb(String name, DatabaseMigrationsSqlDbArgs args, CustomResourceOptions options)
type: azure-native:datamigration:DatabaseMigrationsSqlDb
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args DatabaseMigrationsSqlDbArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args DatabaseMigrationsSqlDbArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args DatabaseMigrationsSqlDbArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args DatabaseMigrationsSqlDbArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args DatabaseMigrationsSqlDbArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

DatabaseMigrationsSqlDb Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The DatabaseMigrationsSqlDb resource accepts the following input properties:

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
Properties Pulumi.AzureNative.DataMigration.Inputs.DatabaseMigrationPropertiesSqlDbArgs

Database Migration Resource properties for SQL database.

TargetDbName string

The name of the target database.

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
Properties DatabaseMigrationPropertiesSqlDbArgs

Database Migration Resource properties for SQL database.

TargetDbName string

The name of the target database.

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
properties DatabaseMigrationPropertiesSqlDbArgs

Database Migration Resource properties for SQL database.

targetDbName String

The name of the target database.

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
properties DatabaseMigrationPropertiesSqlDbArgs

Database Migration Resource properties for SQL database.

targetDbName string

The name of the target database.

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
properties DatabaseMigrationPropertiesSqlDbArgs

Database Migration Resource properties for SQL database.

target_db_name str

The name of the target database.

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
properties Property Map

Database Migration Resource properties for SQL database.

targetDbName String

The name of the target database.

Outputs

All input properties are implicitly available as output properties. Additionally, the DatabaseMigrationsSqlDb resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

Name string
SystemData Pulumi.AzureNative.DataMigration.Outputs.SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

Type string
Id string

The provider-assigned unique ID for this managed resource.

Name string
SystemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

Type string
id String

The provider-assigned unique ID for this managed resource.

name String
systemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type String
id string

The provider-assigned unique ID for this managed resource.

name string
systemData SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type string
id str

The provider-assigned unique ID for this managed resource.

name str
system_data SystemDataResponse

Metadata pertaining to creation and last modification of the resource.

type str
id String

The provider-assigned unique ID for this managed resource.

name String
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.

DatabaseMigrationPropertiesSqlDb

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.SqlConnectionInformation

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.SqlConnectionInformation

Target SQL DB connection details.

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 SqlConnectionInformation

Source SQL Server connection details.

TableList []string

List of tables to copy.

TargetDatabaseCollation string

Database collation to be used for the target database.

TargetSqlConnection SqlConnectionInformation

Target SQL DB connection details.

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 SqlConnectionInformation

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 SqlConnectionInformation

Target SQL DB connection details.

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 SqlConnectionInformation

Source SQL Server connection details.

tableList string[]

List of tables to copy.

targetDatabaseCollation string

Database collation to be used for the target database.

targetSqlConnection SqlConnectionInformation

Target SQL DB connection details.

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 SqlConnectionInformation

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 SqlConnectionInformation

Target SQL DB connection details.

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.

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.

SqlConnectionInformation

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.

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

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:datamigration:DatabaseMigrationsSqlDb db1 /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance/providers/Microsoft.DataMigration/databaseMigrations/db1 

Package Details

Repository
https://github.com/pulumi/pulumi-azure-native
License
Apache-2.0