Docs Packages
  1. Packages
  2. Azure Native
  3. API Docs
  4. datamigration
  5. DatabaseMigrationsSqlDb
Azure Native v1.103.0 published on Friday, Jun 2, 2023 by Pulumi
pulumi/pulumi-azure-native

azure-native.datamigration.DatabaseMigrationsSqlDb

Explore with Pulumi AI

azure-native logo
Azure Native v1.103.0 published on Friday, Jun 2, 2023 by Pulumi
pulumi/pulumi-azure-native

    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 System.Linq;
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=azure_native.datamigration.DatabaseMigrationPropertiesSqlDbResponseArgs(
        kind="SqlDb",
        migration_service="/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",
        source_database_name="aaa",
        source_sql_connection=azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="WindowsAuthentication",
            data_source="aaa",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
        table_list=[
            "[Schema1].[TableName1]",
            "[Schema2].[TableName2]",
        ],
        target_sql_connection=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 System.Linq;
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=azure_native.datamigration.DatabaseMigrationPropertiesSqlDbResponseArgs(
        kind="SqlDb",
        migration_service="/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",
        source_database_name="aaa",
        source_sql_connection=azure_native.datamigration.SqlConnectionInformationArgs(
            authentication="WindowsAuthentication",
            data_source="aaa",
            encrypt_connection=True,
            password="placeholder",
            trust_server_certificate=True,
            user_name="bbb",
        ),
        target_sql_connection=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 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
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    Azure Native v1.103.0 published on Friday, Jun 2, 2023 by Pulumi
    pulumi/pulumi-azure-native