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

DatabaseMigrationsSqlDb

class DatabaseMigrationsSqlDb : KotlinCustomResource

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",
    });
});

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());
    }
}

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

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