Sql
SQL Assessment REST resource. Uses Azure REST API version 2024-03-03-preview.
Example Usage
SqlAssessmentV3Operations_Create_MaximumSet
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlAssessmentV3Operation = new AzureNative.Migrate.SqlAssessmentV3Operation("sqlAssessmentV3Operation", new()
{
AssessmentName = "assessmentName",
ProjectName = "contosoProject",
Properties = new AzureNative.Migrate.Inputs.SqlAssessmentV3PropertiesArgs
{
FallbackMachineAssessmentArmId = "jfwkifsuigza",
Scope = new AzureNative.Migrate.Inputs.ScopeArgs
{
AzureResourceGraphQuery = "ddqs",
ScopeType = AzureNative.Migrate.ScopeType.ServerGroupId,
ServerGroupId = "ppxcjyrxfmpm",
},
Settings = new AzureNative.Migrate.Inputs.SqlAssessmentSettingsArgs
{
AsyncCommitModeIntent = AzureNative.Migrate.AsyncCommitModeIntent.None,
AzureLocation = "vtpazagckatiezkiwol",
AzureSecurityOfferingType = AzureNative.Migrate.AzureSecurityOfferingType.NO,
AzureSqlDatabaseSettings = new AzureNative.Migrate.Inputs.SqlDbSettingsV3Args
{
AzureSqlComputeTier = AzureNative.Migrate.ComputeTier.Unknown,
AzureSqlDataBaseType = AzureNative.Migrate.AzureSqlDataBaseType.Unknown,
AzureSqlPurchaseModel = AzureNative.Migrate.AzureSqlPurchaseModel.Unknown,
AzureSqlServiceTier = AzureNative.Migrate.AzureSqlServiceTierV3.SqlService_Unknown,
},
AzureSqlManagedInstanceSettings = new AzureNative.Migrate.Inputs.SqlMiSettingsV3Args
{
AzureSqlInstanceType = AzureNative.Migrate.AzureSqlInstanceType.Unknown,
AzureSqlServiceTier = AzureNative.Migrate.AzureSqlServiceTierV3.SqlService_Unknown,
},
AzureSqlVmSettings = new AzureNative.Migrate.Inputs.SqlVmSettingsArgs
{
InstanceSeries = new[]
{
AzureNative.Migrate.AzureVmFamily.Unknown,
},
},
BillingSettings = new AzureNative.Migrate.Inputs.BillingSettingsArgs
{
LicensingProgram = AzureNative.Migrate.LicensingProgram.Retail,
SubscriptionId = "sp",
},
Currency = AzureNative.Migrate.AzureCurrency.Unknown,
DisasterRecoveryLocation = AzureNative.Migrate.AzureLocation.Unknown,
DiscountPercentage = 8,
EnableHadrAssessment = true,
EntityUptime = new AzureNative.Migrate.Inputs.EntityUptimeArgs
{
DaysPerMonth = 2,
HoursPerDay = 28,
},
EnvironmentType = AzureNative.Migrate.EnvironmentType.Production,
IsInternetAccessAvailable = true,
MultiSubnetIntent = AzureNative.Migrate.MultiSubnetIntent.None,
OsLicense = AzureNative.Migrate.OsLicense.Unknown,
PerformanceData = new AzureNative.Migrate.Inputs.PerformanceDataArgs
{
Percentile = "Unknown",
PerfDataEndTime = "2025-02-21T05:15:28.133Z",
PerfDataStartTime = "2025-02-21T05:15:28.133Z",
TimeRange = AzureNative.Migrate.TimeRange.Day,
},
PreferredTargets = new[]
{
AzureNative.Migrate.AzureTarget.Unknown,
},
SavingsSettings = new AzureNative.Migrate.Inputs.SavingsSettingsArgs
{
AzureOfferCode = AzureNative.Migrate.AzureOffer.Unknown,
SavingsOptions = AzureNative.Migrate.SavingsOptions.None,
},
ScalingFactor = 27,
SizingCriterion = AzureNative.Migrate.AssessmentSizingCriterion.PerformanceBased,
SqlServerLicense = AzureNative.Migrate.SqlServerLicense.Unknown,
},
},
ResourceGroupName = "rgsqlAssessments",
});
});Content copied to clipboard
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.NewSqlAssessmentV3Operation(ctx, "sqlAssessmentV3Operation", &migrate.SqlAssessmentV3OperationArgs{
AssessmentName: pulumi.String("assessmentName"),
ProjectName: pulumi.String("contosoProject"),
Properties: &migrate.SqlAssessmentV3PropertiesArgs{
FallbackMachineAssessmentArmId: pulumi.String("jfwkifsuigza"),
Scope: &migrate.ScopeArgs{
AzureResourceGraphQuery: pulumi.String("ddqs"),
ScopeType: pulumi.String(migrate.ScopeTypeServerGroupId),
ServerGroupId: pulumi.String("ppxcjyrxfmpm"),
},
Settings: &migrate.SqlAssessmentSettingsArgs{
AsyncCommitModeIntent: pulumi.String(migrate.AsyncCommitModeIntentNone),
AzureLocation: pulumi.String("vtpazagckatiezkiwol"),
AzureSecurityOfferingType: pulumi.String(migrate.AzureSecurityOfferingTypeNO),
AzureSqlDatabaseSettings: &migrate.SqlDbSettingsV3Args{
AzureSqlComputeTier: pulumi.String(migrate.ComputeTierUnknown),
AzureSqlDataBaseType: pulumi.String(migrate.AzureSqlDataBaseTypeUnknown),
AzureSqlPurchaseModel: pulumi.String(migrate.AzureSqlPurchaseModelUnknown),
AzureSqlServiceTier: pulumi.String(migrate.AzureSqlServiceTierV3_SqlService_Unknown),
},
AzureSqlManagedInstanceSettings: &migrate.SqlMiSettingsV3Args{
AzureSqlInstanceType: pulumi.String(migrate.AzureSqlInstanceTypeUnknown),
AzureSqlServiceTier: pulumi.String(migrate.AzureSqlServiceTierV3_SqlService_Unknown),
},
AzureSqlVmSettings: &migrate.SqlVmSettingsArgs{
InstanceSeries: pulumi.StringArray{
pulumi.String(migrate.AzureVmFamilyUnknown),
},
},
BillingSettings: &migrate.BillingSettingsArgs{
LicensingProgram: pulumi.String(migrate.LicensingProgramRetail),
SubscriptionId: pulumi.String("sp"),
},
Currency: pulumi.String(migrate.AzureCurrencyUnknown),
DisasterRecoveryLocation: pulumi.String(migrate.AzureLocationUnknown),
DiscountPercentage: pulumi.Float64(8),
EnableHadrAssessment: pulumi.Bool(true),
EntityUptime: &migrate.EntityUptimeArgs{
DaysPerMonth: pulumi.Int(2),
HoursPerDay: pulumi.Int(28),
},
EnvironmentType: pulumi.String(migrate.EnvironmentTypeProduction),
IsInternetAccessAvailable: pulumi.Bool(true),
MultiSubnetIntent: pulumi.String(migrate.MultiSubnetIntentNone),
OsLicense: pulumi.String(migrate.OsLicenseUnknown),
PerformanceData: &migrate.PerformanceDataArgs{
Percentile: pulumi.String("Unknown"),
PerfDataEndTime: pulumi.String("2025-02-21T05:15:28.133Z"),
PerfDataStartTime: pulumi.String("2025-02-21T05:15:28.133Z"),
TimeRange: pulumi.String(migrate.TimeRangeDay),
},
PreferredTargets: pulumi.StringArray{
pulumi.String(migrate.AzureTargetUnknown),
},
SavingsSettings: &migrate.SavingsSettingsArgs{
AzureOfferCode: pulumi.String(migrate.AzureOfferUnknown),
SavingsOptions: pulumi.String(migrate.SavingsOptionsNone),
},
ScalingFactor: pulumi.Float64(27),
SizingCriterion: pulumi.String(migrate.AssessmentSizingCriterionPerformanceBased),
SqlServerLicense: pulumi.String(migrate.SqlServerLicenseUnknown),
},
},
ResourceGroupName: pulumi.String("rgsqlAssessments"),
})
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.migrate.SqlAssessmentV3Operation;
import com.pulumi.azurenative.migrate.SqlAssessmentV3OperationArgs;
import com.pulumi.azurenative.migrate.inputs.SqlAssessmentV3PropertiesArgs;
import com.pulumi.azurenative.migrate.inputs.ScopeArgs;
import com.pulumi.azurenative.migrate.inputs.SqlAssessmentSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.SqlDbSettingsV3Args;
import com.pulumi.azurenative.migrate.inputs.SqlMiSettingsV3Args;
import com.pulumi.azurenative.migrate.inputs.SqlVmSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.BillingSettingsArgs;
import com.pulumi.azurenative.migrate.inputs.EntityUptimeArgs;
import com.pulumi.azurenative.migrate.inputs.PerformanceDataArgs;
import com.pulumi.azurenative.migrate.inputs.SavingsSettingsArgs;
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 sqlAssessmentV3Operation = new SqlAssessmentV3Operation("sqlAssessmentV3Operation", SqlAssessmentV3OperationArgs.builder()
.assessmentName("assessmentName")
.projectName("contosoProject")
.properties(SqlAssessmentV3PropertiesArgs.builder()
.fallbackMachineAssessmentArmId("jfwkifsuigza")
.scope(ScopeArgs.builder()
.azureResourceGraphQuery("ddqs")
.scopeType("ServerGroupId")
.serverGroupId("ppxcjyrxfmpm")
.build())
.settings(SqlAssessmentSettingsArgs.builder()
.asyncCommitModeIntent("None")
.azureLocation("vtpazagckatiezkiwol")
.azureSecurityOfferingType("NO")
.azureSqlDatabaseSettings(SqlDbSettingsV3Args.builder()
.azureSqlComputeTier("Unknown")
.azureSqlDataBaseType("Unknown")
.azureSqlPurchaseModel("Unknown")
.azureSqlServiceTier("SqlService_Unknown")
.build())
.azureSqlManagedInstanceSettings(SqlMiSettingsV3Args.builder()
.azureSqlInstanceType("Unknown")
.azureSqlServiceTier("SqlService_Unknown")
.build())
.azureSqlVmSettings(SqlVmSettingsArgs.builder()
.instanceSeries("Unknown")
.build())
.billingSettings(BillingSettingsArgs.builder()
.licensingProgram("Retail")
.subscriptionId("sp")
.build())
.currency("Unknown")
.disasterRecoveryLocation("Unknown")
.discountPercentage(8.0)
.enableHadrAssessment(true)
.entityUptime(EntityUptimeArgs.builder()
.daysPerMonth(2)
.hoursPerDay(28)
.build())
.environmentType("Production")
.isInternetAccessAvailable(true)
.multiSubnetIntent("None")
.osLicense("Unknown")
.performanceData(PerformanceDataArgs.builder()
.percentile("Unknown")
.perfDataEndTime("2025-02-21T05:15:28.133Z")
.perfDataStartTime("2025-02-21T05:15:28.133Z")
.timeRange("Day")
.build())
.preferredTargets("Unknown")
.savingsSettings(SavingsSettingsArgs.builder()
.azureOfferCode("Unknown")
.savingsOptions("None")
.build())
.scalingFactor(27.0)
.sizingCriterion("PerformanceBased")
.sqlServerLicense("Unknown")
.build())
.build())
.resourceGroupName("rgsqlAssessments")
.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:migrate:SqlAssessmentV3Operation assessmentName /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Migrate/assessmentProjects/{projectName}/sqlAssessments/{assessmentName}Content copied to clipboard
Properties
Link copied to clipboard
The Azure API version of the resource.
Link copied to clipboard
The resource-specific properties for this resource.
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Azure Resource Manager metadata containing createdBy and modifiedBy information.