1. Packages
  2. Azure Native
  3. API Docs
  4. datamigration
  5. DatabaseMigrationsSqlDb
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.19.0 published on Tuesday, Nov 21, 2023 by Pulumi

azure-native.datamigration.DatabaseMigrationsSqlDb

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.19.0 published on Tuesday, Nov 21, 2023 by Pulumi

    Database Migration Resource for SQL Database. Azure REST API version: 2022-03-30-preview. Prior API version in Azure Native 1.x: 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",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/datamigration/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
    _, err := datamigration.NewDatabaseMigrationsSqlDb(ctx, "databaseMigrationsSqlDb", &datamigration.DatabaseMigrationsSqlDbArgs{
    Properties: interface{}{
    Kind: pulumi.String("SqlDb"),
    MigrationService: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent"),
    Scope: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance"),
    SourceDatabaseName: pulumi.String("aaa"),
    SourceSqlConnection: &datamigration.SqlConnectionInformationArgs{
    Authentication: pulumi.String("WindowsAuthentication"),
    DataSource: pulumi.String("aaa"),
    EncryptConnection: pulumi.Bool(true),
    Password: pulumi.String("placeholder"),
    TrustServerCertificate: pulumi.Bool(true),
    UserName: pulumi.String("bbb"),
    },
    TableList: pulumi.StringArray{
    pulumi.String("[Schema1].[TableName1]"),
    pulumi.String("[Schema2].[TableName2]"),
    },
    TargetSqlConnection: &datamigration.SqlConnectionInformationArgs{
    Authentication: pulumi.String("SqlAuthentication"),
    DataSource: pulumi.String("sqldbinstance"),
    EncryptConnection: pulumi.Bool(true),
    Password: pulumi.String("placeholder"),
    TrustServerCertificate: pulumi.Bool(true),
    UserName: pulumi.String("bbb"),
    },
    },
    ResourceGroupName: pulumi.String("testrg"),
    SqlDbInstanceName: pulumi.String("sqldbinstance"),
    TargetDbName: pulumi.String("db1"),
    })
    if err != nil {
    return err
    }
    return nil
    })
    }
    
    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",
        });
    
    });
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure-native-sdk/datamigration/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
    _, err := datamigration.NewDatabaseMigrationsSqlDb(ctx, "databaseMigrationsSqlDb", &datamigration.DatabaseMigrationsSqlDbArgs{
    Properties: interface{}{
    Kind: pulumi.String("SqlDb"),
    MigrationService: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.DataMigration/sqlMigrationServices/testagent"),
    Scope: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Sql/servers/sqldbinstance"),
    SourceDatabaseName: pulumi.String("aaa"),
    SourceSqlConnection: &datamigration.SqlConnectionInformationArgs{
    Authentication: pulumi.String("WindowsAuthentication"),
    DataSource: pulumi.String("aaa"),
    EncryptConnection: pulumi.Bool(true),
    Password: pulumi.String("placeholder"),
    TrustServerCertificate: pulumi.Bool(true),
    UserName: pulumi.String("bbb"),
    },
    TargetSqlConnection: &datamigration.SqlConnectionInformationArgs{
    Authentication: pulumi.String("SqlAuthentication"),
    DataSource: pulumi.String("sqldbinstance"),
    EncryptConnection: pulumi.Bool(true),
    Password: pulumi.String("placeholder"),
    TrustServerCertificate: pulumi.Bool(true),
    UserName: pulumi.String("bbb"),
    },
    },
    ResourceGroupName: pulumi.String("testrg"),
    SqlDbInstanceName: pulumi.String("sqldbinstance"),
    TargetDbName: pulumi.String("db1"),
    })
    if err != nil {
    return err
    }
    return nil
    })
    }
    
    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.DatabaseMigrationPropertiesSqlDb

    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 DatabaseMigrationPropertiesSqlDb

    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 DatabaseMigrationPropertiesSqlDb

    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, CopyProgressDetailsResponseArgs

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

    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, DatabaseMigrationPropertiesSqlDbResponseArgs

    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, ErrorInfoResponseArgs

    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, SqlConnectionInformationArgs

    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, SqlConnectionInformationResponseArgs

    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, SqlDbMigrationStatusDetailsResponseArgs

    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, SqlDbOfflineConfigurationResponseArgs

    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, SystemDataResponseArgs

    CreatedAt string

    The timestamp of resource creation (UTC).

    CreatedBy string

    The identity that created the resource.

    CreatedByType string

    The type of identity that created the resource.

    LastModifiedAt string

    The timestamp of resource last modification (UTC)

    LastModifiedBy string

    The identity that last modified the resource.

    LastModifiedByType string

    The type of identity that last modified the resource.

    CreatedAt string

    The timestamp of resource creation (UTC).

    CreatedBy string

    The identity that created the resource.

    CreatedByType string

    The type of identity that created the resource.

    LastModifiedAt string

    The timestamp of resource last modification (UTC)

    LastModifiedBy string

    The identity that last modified the resource.

    LastModifiedByType string

    The type of identity that last modified the resource.

    createdAt String

    The timestamp of resource creation (UTC).

    createdBy String

    The identity that created the resource.

    createdByType String

    The type of identity that created the resource.

    lastModifiedAt String

    The timestamp of resource last modification (UTC)

    lastModifiedBy String

    The identity that last modified the resource.

    lastModifiedByType String

    The type of identity that last modified the resource.

    createdAt string

    The timestamp of resource creation (UTC).

    createdBy string

    The identity that created the resource.

    createdByType string

    The type of identity that created the resource.

    lastModifiedAt string

    The timestamp of resource last modification (UTC)

    lastModifiedBy string

    The identity that last modified the resource.

    lastModifiedByType string

    The type of identity that last modified the resource.

    created_at str

    The timestamp of resource creation (UTC).

    created_by str

    The identity that created the resource.

    created_by_type str

    The type of identity that created the resource.

    last_modified_at str

    The timestamp of resource last modification (UTC)

    last_modified_by str

    The identity that last modified the resource.

    last_modified_by_type str

    The type of identity that last modified the resource.

    createdAt String

    The timestamp of resource creation (UTC).

    createdBy String

    The identity that created the resource.

    createdByType String

    The type of identity that created the resource.

    lastModifiedAt String

    The timestamp of resource last modification (UTC)

    lastModifiedBy String

    The identity that last modified the resource.

    lastModifiedByType String

    The type of identity that last modified the resource.

    Import

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

    $ pulumi import azure-native:datamigration:DatabaseMigrationsSqlDb db1 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{sqlDbInstanceName}/providers/Microsoft.DataMigration/databaseMigrations/{targetDbName} 
    

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.19.0 published on Tuesday, Nov 21, 2023 by Pulumi