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

DatabaseMigrationsSqlDb

class DatabaseMigrationsSqlDb : KotlinCustomResource

Database Migration Resource for SQL Database. Uses Azure REST API version 2023-07-15-preview. In version 2.x of the Azure Native provider, it used API version 2022-03-30-preview. Other available API versions: 2022-03-30-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native datamigration [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

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 (
	datamigration "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: &datamigration.DatabaseMigrationPropertiesSqlDbArgs{
				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 com.pulumi.azurenative.datamigration.inputs.DatabaseMigrationPropertiesSqlDbArgs;
import com.pulumi.azurenative.datamigration.inputs.SqlConnectionInformationArgs;
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(DatabaseMigrationPropertiesSqlDbArgs.builder()
                .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(SqlConnectionInformationArgs.builder()
                    .authentication("WindowsAuthentication")
                    .dataSource("aaa")
                    .encryptConnection(true)
                    .password("placeholder")
                    .trustServerCertificate(true)
                    .userName("bbb")
                    .build())
                .tableList(
                    "[Schema1].[TableName1]",
                    "[Schema2].[TableName2]")
                .targetSqlConnection(SqlConnectionInformationArgs.builder()
                    .authentication("SqlAuthentication")
                    .dataSource("sqldbinstance")
                    .encryptConnection(true)
                    .password("placeholder")
                    .trustServerCertificate(true)
                    .userName("bbb")
                    .build())
                .build())
            .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 (
	datamigration "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: &datamigration.DatabaseMigrationPropertiesSqlDbArgs{
				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 com.pulumi.azurenative.datamigration.inputs.DatabaseMigrationPropertiesSqlDbArgs;
import com.pulumi.azurenative.datamigration.inputs.SqlConnectionInformationArgs;
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(DatabaseMigrationPropertiesSqlDbArgs.builder()
                .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(SqlConnectionInformationArgs.builder()
                    .authentication("WindowsAuthentication")
                    .dataSource("aaa")
                    .encryptConnection(true)
                    .password("placeholder")
                    .trustServerCertificate(true)
                    .userName("bbb")
                    .build())
                .targetSqlConnection(SqlConnectionInformationArgs.builder()
                    .authentication("SqlAuthentication")
                    .dataSource("sqldbinstance")
                    .encryptConnection(true)
                    .password("placeholder")
                    .trustServerCertificate(true)
                    .userName("bbb")
                    .build())
                .build())
            .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

Properties

Link copied to clipboard
val azureApiVersion: Output<String>

The Azure API version of the resource.

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val name: Output<String>
Link copied to clipboard
val properties: Output<DatabaseMigrationPropertiesSqlDbResponse>

Database Migration Resource properties for SQL database.

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
val systemData: Output<SystemDataResponse>

Metadata pertaining to creation and last modification of the resource.

Link copied to clipboard
val type: Output<String>
Link copied to clipboard
val urn: Output<String>