pulumi-azure-native-kotlin/com.pulumi.azurenative.datamigration.kotlin/DatabaseMigrationsSqlDbArgs

DatabaseMigrationsSqlDbArgs

data class DatabaseMigrationsSqlDbArgs(val properties: Output<DatabaseMigrationPropertiesSqlDbArgs>? = null, val resourceGroupName: Output<String>? = null, val sqlDbInstanceName: Output<String>? = null, val targetDbName: Output<String>? = null) : ConvertibleToJava<DatabaseMigrationsSqlDbArgs>

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",
    });
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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",
    });
});
Content copied to clipboard
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
})
}
Content copied to clipboard
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());
    }
}
Content copied to clipboard

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}
Content copied to clipboard

Constructors

Link copied to clipboard
fun DatabaseMigrationsSqlDbArgs(properties: Output<DatabaseMigrationPropertiesSqlDbArgs>? = null, resourceGroupName: Output<String>? = null, sqlDbInstanceName: Output<String>? = null, targetDbName: Output<String>? = null)

Functions

Link copied to clipboard
open override fun toJava(): DatabaseMigrationsSqlDbArgs

Properties

Link copied to clipboard
val properties: Output<DatabaseMigrationPropertiesSqlDbArgs>? = null

Database Migration Resource properties for SQL database.

Link copied to clipboard
val resourceGroupName: Output<String>? = null

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

Link copied to clipboard
val sqlDbInstanceName: Output<String>? = null
Link copied to clipboard
val targetDbName: Output<String>? = null

The name of the target database.