1. Packages
  2. Azure Native v1
  3. API Docs
  4. datamigration
  5. DatabaseMigrationsSqlDb
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi

azure-native.datamigration.DatabaseMigrationsSqlDb

Explore with Pulumi AI

azure-native-v1 logo
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi

    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

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new DatabaseMigrationsSqlDb(name: string, args: DatabaseMigrationsSqlDbArgs, opts?: CustomResourceOptions);
    @overload
    def DatabaseMigrationsSqlDb(resource_name: str,
                                args: DatabaseMigrationsSqlDbArgs,
                                opts: Optional[ResourceOptions] = None)
    
    @overload
    def DatabaseMigrationsSqlDb(resource_name: str,
                                opts: Optional[ResourceOptions] = None,
                                resource_group_name: Optional[str] = None,
                                sql_db_instance_name: Optional[str] = None,
                                properties: Optional[DatabaseMigrationPropertiesSqlDbArgs] = None,
                                target_db_name: Optional[str] = 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.
    
    

    Parameters

    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.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var databaseMigrationsSqlDbResource = new AzureNative.Datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDbResource", new()
    {
        ResourceGroupName = "string",
        SqlDbInstanceName = "string",
        Properties = 
        {
            { "kind", "SqlDb" },
            { "migrationOperationId", "string" },
            { "migrationService", "string" },
            { "provisioningError", "string" },
            { "scope", "string" },
            { "sourceDatabaseName", "string" },
            { "sourceSqlConnection", 
            {
                { "authentication", "string" },
                { "dataSource", "string" },
                { "encryptConnection", false },
                { "password", "string" },
                { "trustServerCertificate", false },
                { "userName", "string" },
            } },
            { "tableList", new[]
            {
                "string",
            } },
            { "targetDatabaseCollation", "string" },
            { "targetSqlConnection", 
            {
                { "authentication", "string" },
                { "dataSource", "string" },
                { "encryptConnection", false },
                { "password", "string" },
                { "trustServerCertificate", false },
                { "userName", "string" },
            } },
        },
        TargetDbName = "string",
    });
    
    example, err := datamigration.NewDatabaseMigrationsSqlDb(ctx, "databaseMigrationsSqlDbResource", &datamigration.DatabaseMigrationsSqlDbArgs{
    	ResourceGroupName: "string",
    	SqlDbInstanceName: "string",
    	Properties: map[string]interface{}{
    		"kind":                 "SqlDb",
    		"migrationOperationId": "string",
    		"migrationService":     "string",
    		"provisioningError":    "string",
    		"scope":                "string",
    		"sourceDatabaseName":   "string",
    		"sourceSqlConnection": map[string]interface{}{
    			"authentication":         "string",
    			"dataSource":             "string",
    			"encryptConnection":      false,
    			"password":               "string",
    			"trustServerCertificate": false,
    			"userName":               "string",
    		},
    		"tableList": []string{
    			"string",
    		},
    		"targetDatabaseCollation": "string",
    		"targetSqlConnection": map[string]interface{}{
    			"authentication":         "string",
    			"dataSource":             "string",
    			"encryptConnection":      false,
    			"password":               "string",
    			"trustServerCertificate": false,
    			"userName":               "string",
    		},
    	},
    	TargetDbName: "string",
    })
    
    var databaseMigrationsSqlDbResource = new DatabaseMigrationsSqlDb("databaseMigrationsSqlDbResource", DatabaseMigrationsSqlDbArgs.builder()
        .resourceGroupName("string")
        .sqlDbInstanceName("string")
        .properties(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
        .targetDbName("string")
        .build());
    
    database_migrations_sql_db_resource = azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDbResource",
        resource_group_name=string,
        sql_db_instance_name=string,
        properties={
            kind: SqlDb,
            migrationOperationId: string,
            migrationService: string,
            provisioningError: string,
            scope: string,
            sourceDatabaseName: string,
            sourceSqlConnection: {
                authentication: string,
                dataSource: string,
                encryptConnection: False,
                password: string,
                trustServerCertificate: False,
                userName: string,
            },
            tableList: [string],
            targetDatabaseCollation: string,
            targetSqlConnection: {
                authentication: string,
                dataSource: string,
                encryptConnection: False,
                password: string,
                trustServerCertificate: False,
                userName: string,
            },
        },
        target_db_name=string)
    
    const databaseMigrationsSqlDbResource = new azure_native.datamigration.DatabaseMigrationsSqlDb("databaseMigrationsSqlDbResource", {
        resourceGroupName: "string",
        sqlDbInstanceName: "string",
        properties: {
            kind: "SqlDb",
            migrationOperationId: "string",
            migrationService: "string",
            provisioningError: "string",
            scope: "string",
            sourceDatabaseName: "string",
            sourceSqlConnection: {
                authentication: "string",
                dataSource: "string",
                encryptConnection: false,
                password: "string",
                trustServerCertificate: false,
                userName: "string",
            },
            tableList: ["string"],
            targetDatabaseCollation: "string",
            targetSqlConnection: {
                authentication: "string",
                dataSource: "string",
                encryptConnection: false,
                password: "string",
                trustServerCertificate: false,
                userName: "string",
            },
        },
        targetDbName: "string",
    });
    
    type: azure-native:datamigration:DatabaseMigrationsSqlDb
    properties:
        properties:
            kind: SqlDb
            migrationOperationId: string
            migrationService: string
            provisioningError: string
            scope: string
            sourceDatabaseName: string
            sourceSqlConnection:
                authentication: string
                dataSource: string
                encryptConnection: false
                password: string
                trustServerCertificate: false
                userName: string
            tableList:
                - string
            targetDatabaseCollation: string
            targetSqlConnection:
                authentication: string
                dataSource: string
                encryptConnection: false
                password: string
                trustServerCertificate: false
                userName: string
        resourceGroupName: string
        sqlDbInstanceName: string
        targetDbName: string
    

    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

    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 
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    azure-native-v1 pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native-v1 logo
    These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
    Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi