pulumi-azure-native-kotlin/com.pulumi.azurenative.dbforpostgresql.kotlin/Migration

Migration

class Migration : KotlinCustomResource

Represents a migration resource. Uses Azure REST API version 2024-08-01. In version 2.x of the Azure Native provider, it used API version 2023-03-01-preview. Other available API versions: 2023-03-01-preview, 2023-06-01-preview, 2023-12-01-preview, 2024-03-01-preview, 2024-11-01-preview, 2025-01-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native dbforpostgresql [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.

Example Usage

Create Migration with other source types for Validate and Migrate

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        MigrationOption = AzureNative.DBforPostgreSQL.MigrationOption.ValidateAndMigrate,
        OverwriteDbsInTarget = AzureNative.DBforPostgreSQL.OverwriteDbsInTargetEnum.True,
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
        },
        SourceDbServerResourceId = "testsource:5432@pguser",
        SourceType = AzureNative.DBforPostgreSQL.SourceType.OnPremises,
        SslMode = AzureNative.DBforPostgreSQL.SslMode.Prefer,
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:             pulumi.String("westus"),
			MigrationMode:        pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:        pulumi.String("testmigration"),
			MigrationOption:      pulumi.String(dbforpostgresql.MigrationOptionValidateAndMigrate),
			OverwriteDbsInTarget: pulumi.String(dbforpostgresql.OverwriteDbsInTargetEnumTrue),
			ResourceGroupName:    pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
			},
			SourceDbServerResourceId: pulumi.String("testsource:5432@pguser"),
			SourceType:               pulumi.String(dbforpostgresql.SourceTypeOnPremises),
			SslMode:                  pulumi.String(dbforpostgresql.SslModePrefer),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .migrationOption("ValidateAndMigrate")
            .overwriteDbsInTarget("True")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .build())
            .sourceDbServerResourceId("testsource:5432@pguser")
            .sourceType("OnPremises")
            .sslMode("Prefer")
            .targetDbServerName("testtarget")
            .build());
    }
}
Content copied to clipboard

Create Pre-migration Validation

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        MigrationOption = AzureNative.DBforPostgreSQL.MigrationOption.Validate,
        OverwriteDbsInTarget = AzureNative.DBforPostgreSQL.OverwriteDbsInTargetEnum.True,
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
        },
        SourceDbServerResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource",
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:             pulumi.String("westus"),
			MigrationMode:        pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:        pulumi.String("testmigration"),
			MigrationOption:      pulumi.String(dbforpostgresql.MigrationOptionValidate),
			OverwriteDbsInTarget: pulumi.String(dbforpostgresql.OverwriteDbsInTargetEnumTrue),
			ResourceGroupName:    pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
			},
			SourceDbServerResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource"),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .migrationOption("Validate")
            .overwriteDbsInTarget("True")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .build())
            .sourceDbServerResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource")
            .targetDbServerName("testtarget")
            .build());
    }
}
Content copied to clipboard

Migrations Create by passing user names

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
            SourceServerUsername = "newadmin@testsource",
            TargetServerUsername = "targetadmin",
        },
        SourceDbServerResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource",
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:          pulumi.String("westus"),
			MigrationMode:     pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:     pulumi.String("testmigration"),
			ResourceGroupName: pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
				SourceServerUsername: pulumi.String("newadmin@testsource"),
				TargetServerUsername: pulumi.String("targetadmin"),
			},
			SourceDbServerResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource"),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .sourceServerUsername("newadmin@testsource")
                .targetServerUsername("targetadmin")
                .build())
            .sourceDbServerResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource")
            .targetDbServerName("testtarget")
            .build());
    }
}
Content copied to clipboard

Migrations Create with private endpoint

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrationInstanceResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration",
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        OverwriteDbsInTarget = AzureNative.DBforPostgreSQL.OverwriteDbsInTargetEnum.True,
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
        },
        SourceDbServerResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource",
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:                    pulumi.String("westus"),
			MigrationInstanceResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration"),
			MigrationMode:               pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:               pulumi.String("testmigration"),
			OverwriteDbsInTarget:        pulumi.String(dbforpostgresql.OverwriteDbsInTargetEnumTrue),
			ResourceGroupName:           pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
			},
			SourceDbServerResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource"),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrationInstanceResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .overwriteDbsInTarget("True")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .build())
            .sourceDbServerResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource")
            .targetDbServerName("testtarget")
            .build());
    }
}
Content copied to clipboard

Migrations Create with roles

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrateRoles = AzureNative.DBforPostgreSQL.MigrateRolesEnum.True,
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        OverwriteDbsInTarget = AzureNative.DBforPostgreSQL.OverwriteDbsInTargetEnum.True,
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
        },
        SourceDbServerResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource",
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:             pulumi.String("westus"),
			MigrateRoles:         pulumi.String(dbforpostgresql.MigrateRolesEnumTrue),
			MigrationMode:        pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:        pulumi.String("testmigration"),
			OverwriteDbsInTarget: pulumi.String(dbforpostgresql.OverwriteDbsInTargetEnumTrue),
			ResourceGroupName:    pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
			},
			SourceDbServerResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource"),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrateRoles("True")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .overwriteDbsInTarget("True")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .build())
            .sourceDbServerResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource")
            .targetDbServerName("testtarget")
            .build());
    }
}
Content copied to clipboard

Migrations_Create

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
    var migration = new AzureNative.DBforPostgreSQL.Migration("migration", new()
    {
        DbsToMigrate = new[]
        {
            "db1",
            "db2",
            "db3",
            "db4",
        },
        Location = "westus",
        MigrationInstanceResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration",
        MigrationMode = AzureNative.DBforPostgreSQL.MigrationMode.Offline,
        MigrationName = "testmigration",
        OverwriteDbsInTarget = AzureNative.DBforPostgreSQL.OverwriteDbsInTargetEnum.True,
        ResourceGroupName = "testrg",
        SecretParameters = new AzureNative.DBforPostgreSQL.Inputs.MigrationSecretParametersArgs
        {
            AdminCredentials = new AzureNative.DBforPostgreSQL.Inputs.AdminCredentialsArgs
            {
                SourceServerPassword = "xxxxxxxx",
                TargetServerPassword = "xxxxxxxx",
            },
        },
        SourceDbServerResourceId = "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource",
        TargetDbServerName = "testtarget",
    });
});
Content copied to clipboard
package main
import (
	dbforpostgresql "github.com/pulumi/pulumi-azure-native-sdk/dbforpostgresql/v3"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := dbforpostgresql.NewMigration(ctx, "migration", &dbforpostgresql.MigrationArgs{
			DbsToMigrate: pulumi.StringArray{
				pulumi.String("db1"),
				pulumi.String("db2"),
				pulumi.String("db3"),
				pulumi.String("db4"),
			},
			Location:                    pulumi.String("westus"),
			MigrationInstanceResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration"),
			MigrationMode:               pulumi.String(dbforpostgresql.MigrationModeOffline),
			MigrationName:               pulumi.String("testmigration"),
			OverwriteDbsInTarget:        pulumi.String(dbforpostgresql.OverwriteDbsInTargetEnumTrue),
			ResourceGroupName:           pulumi.String("testrg"),
			SecretParameters: &dbforpostgresql.MigrationSecretParametersArgs{
				AdminCredentials: &dbforpostgresql.AdminCredentialsArgs{
					SourceServerPassword: pulumi.String("xxxxxxxx"),
					TargetServerPassword: pulumi.String("xxxxxxxx"),
				},
			},
			SourceDbServerResourceId: pulumi.String("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource"),
			TargetDbServerName:       pulumi.String("testtarget"),
		})
		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.dbforpostgresql.Migration;
import com.pulumi.azurenative.dbforpostgresql.MigrationArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.MigrationSecretParametersArgs;
import com.pulumi.azurenative.dbforpostgresql.inputs.AdminCredentialsArgs;
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 migration = new Migration("migration", MigrationArgs.builder()
            .dbsToMigrate(
                "db1",
                "db2",
                "db3",
                "db4")
            .location("westus")
            .migrationInstanceResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/flexibleServers/testsourcemigration")
            .migrationMode("Offline")
            .migrationName("testmigration")
            .overwriteDbsInTarget("True")
            .resourceGroupName("testrg")
            .secretParameters(MigrationSecretParametersArgs.builder()
                .adminCredentials(AdminCredentialsArgs.builder()
                    .sourceServerPassword("xxxxxxxx")
                    .targetServerPassword("xxxxxxxx")
                    .build())
                .build())
            .sourceDbServerResourceId("/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSql/servers/testsource")
            .targetDbServerName("testtarget")
            .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:dbforpostgresql:Migration testmigration /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations/{migrationName}
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 cancel: Output<String>?

To trigger cancel for entire migration we need to send this flag as True

Link copied to clipboard
val currentStatus: Output<MigrationStatusResponse>

Current status of migration

Link copied to clipboard
val dbsToCancelMigrationOn: Output<List<String>>?

When you want to trigger cancel for specific databases send cancel flag as True and database names in this array

Link copied to clipboard
val dbsToMigrate: Output<List<String>>?

Number of databases to migrate

Link copied to clipboard
val dbsToTriggerCutoverOn: Output<List<String>>?

When you want to trigger cutover for specific databases send triggerCutover flag as True and database names in this array

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val location: Output<String>

The geo-location where the resource lives

Link copied to clipboard
val migrateRoles: Output<String>?

To migrate roles and permissions we need to send this flag as True

Link copied to clipboard
val migrationId: Output<String>

ID for migration, a GUID.

Link copied to clipboard
val migrationInstanceResourceId: Output<String>?

ResourceId of the private endpoint migration instance

Link copied to clipboard
val migrationMode: Output<String>?

There are two types of migration modes Online and Offline

Link copied to clipboard
val migrationOption: Output<String>?

This indicates the supported Migration option for the migration

Link copied to clipboard
val migrationWindowEndTimeInUtc: Output<String>?

End time in UTC for migration window

Link copied to clipboard
val migrationWindowStartTimeInUtc: Output<String>?

Start time in UTC for migration window

Link copied to clipboard
val name: Output<String>

The name of the resource

Link copied to clipboard
val overwriteDbsInTarget: Output<String>?

Indicates whether the databases on the target server can be overwritten, if already present. If set to False, the migration workflow will wait for a confirmation, if it detects that the database already exists.

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
val setupLogicalReplicationOnSourceDbIfNeeded: Output<String>?

Indicates whether to setup LogicalReplicationOnSourceDb, if needed

Link copied to clipboard
val sourceDbServerFullyQualifiedDomainName: Output<String>?

Source server fully qualified domain name (FQDN) or IP address. It is a optional value, if customer provide it, migration service will always use it for connection

Link copied to clipboard
val sourceDbServerMetadata: Output<DbServerMetadataResponse>

Metadata of the source database server

Link copied to clipboard
val sourceDbServerResourceId: Output<String>?

ResourceId of the source database server in case the sourceType is PostgreSQLSingleServer. For other source types this should be ipaddress:port@username or hostname:port@username

Link copied to clipboard
val sourceType: Output<String>?

migration source server type : OnPremises, AWS, GCP, AzureVM, PostgreSQLSingleServer, AWS_RDS, AWS_AURORA, AWS_EC2, GCP_CloudSQL, GCP_AlloyDB, GCP_Compute, or EDB

Link copied to clipboard
val sslMode: Output<String>?

SSL modes for migration. Default SSL mode for PostgreSQLSingleServer is VerifyFull and Prefer for other source types

Link copied to clipboard
val startDataMigration: Output<String>?

Indicates whether the data migration should start right away

Link copied to clipboard
val systemData: Output<SystemDataResponse>

Azure Resource Manager metadata containing createdBy and modifiedBy information.

Link copied to clipboard
val tags: Output<Map<String, String>>?

Resource tags.

Link copied to clipboard
val targetDbServerFullyQualifiedDomainName: Output<String>?

Target server fully qualified domain name (FQDN) or IP address. It is a optional value, if customer provide it, migration service will always use it for connection

Link copied to clipboard
val targetDbServerMetadata: Output<DbServerMetadataResponse>

Metadata of the target database server

Link copied to clipboard
val targetDbServerResourceId: Output<String>

ResourceId of the source database server

Link copied to clipboard
val triggerCutover: Output<String>?

To trigger cutover for entire migration we need to send this flag as True

Link copied to clipboard
val type: Output<String>

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Link copied to clipboard
val urn: Output<String>