Sql
SQL Assessment REST resource. Uses Azure REST API version 2024-01-01-preview. In version 2.x of the Azure Native provider, it used API version 2023-03-15. Other available API versions: 2023-03-15, 2023-04-01-preview, 2023-05-01-preview, 2023-09-09-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native migrate [ApiVersion]. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.
Example Usage
SqlAssessmentV2Operations_Create_MaximumSet_Gen
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlAssessmentV2Operation = new AzureNative.Migrate.SqlAssessmentV2Operation("sqlAssessmentV2Operation", new()
{
AssessmentName = "test_swagger_1",
AsyncCommitModeIntent = AzureNative.Migrate.AsyncCommitModeIntent.DisasterRecovery,
AzureLocation = "SoutheastAsia",
AzureOfferCode = AzureNative.Migrate.AzureOfferCode.Msazr0003P,
AzureOfferCodeForVm = AzureNative.Migrate.AzureOfferCode.Msazr0003P,
AzureSqlDatabaseSettings = new AzureNative.Migrate.Inputs.SqlDbSettingsArgs
{
AzureSqlComputeTier = AzureNative.Migrate.ComputeTier.Automatic,
AzureSqlDataBaseType = AzureNative.Migrate.AzureSqlDataBaseType.SingleDatabase,
AzureSqlPurchaseModel = AzureNative.Migrate.AzureSqlPurchaseModel.VCore,
AzureSqlServiceTier = AzureNative.Migrate.AzureSqlServiceTier.Automatic,
},
AzureSqlManagedInstanceSettings = new AzureNative.Migrate.Inputs.SqlMiSettingsArgs
{
AzureSqlInstanceType = AzureNative.Migrate.AzureSqlInstanceType.SingleInstance,
AzureSqlServiceTier = AzureNative.Migrate.AzureSqlServiceTier.Automatic,
},
AzureSqlVmSettings = new AzureNative.Migrate.Inputs.SqlVmSettingsArgs
{
InstanceSeries = new[]
{
AzureNative.Migrate.AzureVmFamily.Eadsv5Series,
},
},
Currency = AzureNative.Migrate.AzureCurrency.USD,
DisasterRecoveryLocation = AzureNative.Migrate.AzureLocation.EastAsia,
DiscountPercentage = 0,
EnableHadrAssessment = true,
EntityUptime = new AzureNative.Migrate.Inputs.EntityUptimeArgs
{
DaysPerMonth = 30,
HoursPerDay = 24,
},
EnvironmentType = AzureNative.Migrate.EnvironmentType.Production,
GroupName = "test_fci_hadr",
MultiSubnetIntent = AzureNative.Migrate.MultiSubnetIntent.DisasterRecovery,
OptimizationLogic = AzureNative.Migrate.OptimizationLogic.MinimizeCost,
OsLicense = AzureNative.Migrate.OsLicense.Unknown,
Percentile = AzureNative.Migrate.Percentile.Percentile95,
ProjectName = "fci-test6904project",
ReservedInstance = AzureNative.Migrate.AzureReservedInstance.None,
ReservedInstanceForVm = AzureNative.Migrate.AzureReservedInstance.None,
ResourceGroupName = "rgmigrate",
ScalingFactor = 1,
SizingCriterion = AzureNative.Migrate.AssessmentSizingCriterion.PerformanceBased,
SqlServerLicense = AzureNative.Migrate.SqlServerLicense.Unknown,
TimeRange = AzureNative.Migrate.TimeRange.Day,
});
});package main
import (
migrate "github.com/pulumi/pulumi-azure-native-sdk/migrate/v3"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := migrate.NewSqlAssessmentV2Operation(ctx, "sqlAssessmentV2Operation", &migrate.SqlAssessmentV2OperationArgs{
AssessmentName: pulumi.String("test_swagger_1"),
AsyncCommitModeIntent: pulumi.String(migrate.AsyncCommitModeIntentDisasterRecovery),
AzureLocation: pulumi.String("SoutheastAsia"),
AzureOfferCode: pulumi.String(migrate.AzureOfferCodeMsazr0003P),
AzureOfferCodeForVm: pulumi.String(migrate.AzureOfferCodeMsazr0003P),
AzureSqlDatabaseSettings: &migrate.SqlDbSettingsArgs{
AzureSqlComputeTier: pulumi.String(migrate.ComputeTierAutomatic),
AzureSqlDataBaseType: pulumi.String(migrate.AzureSqlDataBaseTypeSingleDatabase),
AzureSqlPurchaseModel: pulumi.String(migrate.AzureSqlPurchaseModelVCore),
AzureSqlServiceTier: pulumi.String(migrate.AzureSqlServiceTierAutomatic),
},
AzureSqlManagedInstanceSettings: &migrate.SqlMiSettingsArgs{
AzureSqlInstanceType: pulumi.String(migrate.AzureSqlInstanceTypeSingleInstance),
AzureSqlServiceTier: pulumi.String(migrate.AzureSqlServiceTierAutomatic),
},
AzureSqlVmSettings: &migrate.SqlVmSettingsArgs{
InstanceSeries: pulumi.StringArray{
pulumi.String(migrate.AzureVmFamilyEadsv5Series),
},
},
Currency: pulumi.String(migrate.AzureCurrencyUSD),
DisasterRecoveryLocation: pulumi.String(migrate.AzureLocationEastAsia),
DiscountPercentage: pulumi.Float64(0),
EnableHadrAssessment: pulumi.Bool(true),
EntityUptime: &migrate.EntityUptimeArgs{
DaysPerMonth: pulumi.Int(30),
HoursPerDay: pulumi.Int(24),
},
EnvironmentType: pulumi.String(migrate.EnvironmentTypeProduction),
GroupName: pulumi.String("test_fci_hadr"),
MultiSubnetIntent: pulumi.String(migrate.MultiSubnetIntentDisasterRecovery),
OptimizationLogic: pulumi.String(migrate.OptimizationLogicMinimizeCost),
OsLicense: pulumi.String(migrate.OsLicenseUnknown),
Percentile: pulumi.String(migrate.PercentilePercentile95),
ProjectName: pulumi.String("fci-test6904project"),
ReservedInstance: pulumi.String(migrate.AzureReservedInstanceNone),
ReservedInstanceForVm: pulumi.String(migrate.AzureReservedInstanceNone),
ResourceGroupName: pulumi.String("rgmigrate"),
ScalingFactor: pulumi.Float64(1),
SizingCriterion: pulumi.String(migrate.AssessmentSizingCriterionPerformanceBased),
SqlServerLicense: pulumi.String(migrate.SqlServerLicenseUnknown),
TimeRange: pulumi.String(migrate.TimeRangeDay),
})
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.migrate.SqlAssessmentV2Operation;
import com.pulumi.azurenative.migrate.SqlAssessmentV2OperationArgs;
import com.pulumi.azurenative.migrate.inputs.SqlDbSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.SqlMiSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.SqlVmSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.EntityUptimeArgs;
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 sqlAssessmentV2Operation = new SqlAssessmentV2Operation("sqlAssessmentV2Operation", SqlAssessmentV2OperationArgs.builder()
.assessmentName("test_swagger_1")
.asyncCommitModeIntent("DisasterRecovery")
.azureLocation("SoutheastAsia")
.azureOfferCode("MSAZR0003P")
.azureOfferCodeForVm("MSAZR0003P")
.azureSqlDatabaseSettings(SqlDbSettingsArgs.builder()
.azureSqlComputeTier("Automatic")
.azureSqlDataBaseType("SingleDatabase")
.azureSqlPurchaseModel("VCore")
.azureSqlServiceTier("Automatic")
.build())
.azureSqlManagedInstanceSettings(SqlMiSettingsArgs.builder()
.azureSqlInstanceType("SingleInstance")
.azureSqlServiceTier("Automatic")
.build())
.azureSqlVmSettings(SqlVmSettingsArgs.builder()
.instanceSeries("Eadsv5_series")
.build())
.currency("USD")
.disasterRecoveryLocation("EastAsia")
.discountPercentage(0.0)
.enableHadrAssessment(true)
.entityUptime(EntityUptimeArgs.builder()
.daysPerMonth(30)
.hoursPerDay(24)
.build())
.environmentType("Production")
.groupName("test_fci_hadr")
.multiSubnetIntent("DisasterRecovery")
.optimizationLogic("MinimizeCost")
.osLicense("Unknown")
.percentile("Percentile95")
.projectName("fci-test6904project")
.reservedInstance("None")
.reservedInstanceForVm("None")
.resourceGroupName("rgmigrate")
.scalingFactor(1.0)
.sizingCriterion("PerformanceBased")
.sqlServerLicense("Unknown")
.timeRange("Day")
.build());
}
}Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:migrate:SqlAssessmentV2Operation test_swagger_1 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Migrate/assessmentProjects/{projectName}/groups/{groupName}/sqlAssessments/{assessmentName}Properties
Assessment type of the assessment.
Gets or sets user preference indicating intent of async commit mode.
The Azure API version of the resource.
Azure Location or Azure region where to which the machines will be migrated.
Azure Offer Code.
Gets or sets Azure Offer Code for VM.
Gets or sets a value indicating azure security offering type.
Gets or sets user configurable SQL database settings.
Gets or sets user configurable SQL managed instance settings.
Gets or sets user configurable SQL VM settings.
Confidence Rating in Percentage.
Date and Time when assessment was created.
Gets or sets the Azure Location or Azure region where to which the machines will be migrated.
Custom discount percentage.
Gets or sets the Enterprise agreement subscription id.
Gets or sets a value indicating whether HADR assessments needs to be created.
Gets or sets the duration for which the entity (SQL, VMs) are up in the on-premises environment.
Gets or sets user configurable setting to display the environment type.
Gets or sets a value indicating whether internet access is available.
Gets or sets user preference indicating intent of multi-subnet configuration.
Gets or sets SQL optimization logic.
Percentile of the utilization data values to be considered while assessing machines.
Gets or sets the end time to consider performance data for assessment.
Gets or sets the start time to consider performance data for assessment.
Last time when rates were queried.
The status of the last operation.
Reserved instance.
Gets or sets azure reserved instance for VM.
Percentage of buffer that user wants on performance metrics when recommending Azure sizes.
Schema version.
Assessment sizing criterion.
SQL server license.
Azure Resource Manager metadata containing createdBy and modifiedBy information.
Date and Time when assessment was last updated.