Migration Args
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",
});
});
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
})
}
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());
}
}
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",
});
});
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
})
}
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());
}
}
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",
});
});
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
})
}
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());
}
}
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",
});
});
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
})
}
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());
}
}
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",
});
});
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
})
}
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());
}
}
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",
});
});
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
})
}
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());
}
}
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}
Constructors
Properties
To trigger cancel for entire migration we need to send this flag as True
When you want to trigger cancel for specific databases send cancel flag as True and database names in this array
Number of databases to migrate
When you want to trigger cutover for specific databases send triggerCutover flag as True and database names in this array
To migrate roles and permissions we need to send this flag as True
ResourceId of the private endpoint migration instance
There are two types of migration modes Online and Offline
The name of the migration.
This indicates the supported Migration option for the migration
End time in UTC for migration window
Start time in UTC for migration window
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.
The resource group name of the target database server.
Migration secret parameters
Indicates whether to setup LogicalReplicationOnSourceDb, if needed
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
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
migration source server type : OnPremises, AWS, GCP, AzureVM, PostgreSQLSingleServer, AWS_RDS, AWS_AURORA, AWS_EC2, GCP_CloudSQL, GCP_AlloyDB, GCP_Compute, or EDB
Indicates whether the data migration should start right away
The subscription ID of the target database server.
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
The name of the target database server.
To trigger cutover for entire migration we need to send this flag as True