Retrieves a SQL Server Instance resource
Uses Azure REST API version 2025-03-01-preview.
Other available API versions: 2023-01-15-preview, 2024-01-01, 2024-05-01-preview, 2026-01-01. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native azurearcdata [ApiVersion]. See the version guide for details.
Using getSqlServerInstance
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getSqlServerInstance(args: GetSqlServerInstanceArgs, opts?: InvokeOptions): Promise<GetSqlServerInstanceResult>
function getSqlServerInstanceOutput(args: GetSqlServerInstanceOutputArgs, opts?: InvokeOptions): Output<GetSqlServerInstanceResult>def get_sql_server_instance(resource_group_name: Optional[str] = None,
sql_server_instance_name: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> GetSqlServerInstanceResult
def get_sql_server_instance_output(resource_group_name: Optional[pulumi.Input[str]] = None,
sql_server_instance_name: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[GetSqlServerInstanceResult]func LookupSqlServerInstance(ctx *Context, args *LookupSqlServerInstanceArgs, opts ...InvokeOption) (*LookupSqlServerInstanceResult, error)
func LookupSqlServerInstanceOutput(ctx *Context, args *LookupSqlServerInstanceOutputArgs, opts ...InvokeOption) LookupSqlServerInstanceResultOutput> Note: This function is named LookupSqlServerInstance in the Go SDK.
public static class GetSqlServerInstance
{
public static Task<GetSqlServerInstanceResult> InvokeAsync(GetSqlServerInstanceArgs args, InvokeOptions? opts = null)
public static Output<GetSqlServerInstanceResult> Invoke(GetSqlServerInstanceInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)
public static Output<GetSqlServerInstanceResult> getSqlServerInstance(GetSqlServerInstanceArgs args, InvokeOptions options)
fn::invoke:
function: azure-native:azurearcdata:getSqlServerInstance
arguments:
# arguments dictionaryThe following arguments are supported:
- Resource
Group stringName - The name of the Azure resource group
- Sql
Server stringInstance Name - Name of SQL Server Instance
- Resource
Group stringName - The name of the Azure resource group
- Sql
Server stringInstance Name - Name of SQL Server Instance
- resource
Group StringName - The name of the Azure resource group
- sql
Server StringInstance Name - Name of SQL Server Instance
- resource
Group stringName - The name of the Azure resource group
- sql
Server stringInstance Name - Name of SQL Server Instance
- resource_
group_ strname - The name of the Azure resource group
- sql_
server_ strinstance_ name - Name of SQL Server Instance
- resource
Group StringName - The name of the Azure resource group
- sql
Server StringInstance Name - Name of SQL Server Instance
getSqlServerInstance Result
The following output properties are available:
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- Location string
- The geo-location where the resource lives
- Name string
- The name of the resource
- Properties
Pulumi.
Azure Native. Azure Arc Data. Outputs. Sql Server Instance Properties Response - null
- System
Data Pulumi.Azure Native. Azure Arc Data. Outputs. System Data Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Dictionary<string, string>
- Resource tags.
- Azure
Api stringVersion - The Azure API version of the resource.
- Id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- Location string
- The geo-location where the resource lives
- Name string
- The name of the resource
- Properties
Sql
Server Instance Properties Response - null
- System
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- map[string]string
- Resource tags.
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location String
- The geo-location where the resource lives
- name String
- The name of the resource
- properties
Sql
Server Instance Properties Response - null
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Map<String,String>
- Resource tags.
- azure
Api stringVersion - The Azure API version of the resource.
- id string
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location string
- The geo-location where the resource lives
- name string
- The name of the resource
- properties
Sql
Server Instance Properties Response - null
- system
Data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- {[key: string]: string}
- Resource tags.
- azure_
api_ strversion - The Azure API version of the resource.
- id str
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location str
- The geo-location where the resource lives
- name str
- The name of the resource
- properties
Sql
Server Instance Properties Response - null
- system_
data SystemData Response - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type str
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Mapping[str, str]
- Resource tags.
- azure
Api StringVersion - The Azure API version of the resource.
- id String
- Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
- location String
- The geo-location where the resource lives
- name String
- The name of the resource
- properties Property Map
- null
- system
Data Property Map - Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Map<String>
- Resource tags.
Supporting Types
AuthenticationResponse
- Mode string
- Mode of authentication in SqlServer.
- Sql
Server List<Pulumi.Entra Identity Azure Native. Azure Arc Data. Inputs. Entra Authentication Response> - Entra Authentication configuration for the SQL Server Instance.
- Mode string
- Mode of authentication in SqlServer.
- Sql
Server []EntraEntra Identity Authentication Response - Entra Authentication configuration for the SQL Server Instance.
- mode String
- Mode of authentication in SqlServer.
- sql
Server List<EntraEntra Identity Authentication Response> - Entra Authentication configuration for the SQL Server Instance.
- mode string
- Mode of authentication in SqlServer.
- sql
Server EntraEntra Identity Authentication Response[] - Entra Authentication configuration for the SQL Server Instance.
- mode str
- Mode of authentication in SqlServer.
- sql_
server_ Sequence[Entraentra_ identity Authentication Response] - Entra Authentication configuration for the SQL Server Instance.
- mode String
- Mode of authentication in SqlServer.
- sql
Server List<Property Map>Entra Identity - Entra Authentication configuration for the SQL Server Instance.
BackupPolicyResponse
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- Differential
Backup intHours - The differential backup interval in hours.
- Full
Backup intDays - The value indicating days between full backups.
- Retention
Period intDays - The retention period for all the databases in this managed instance.
- Transaction
Log intBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup IntegerHours - The differential backup interval in hours.
- full
Backup IntegerDays - The value indicating days between full backups.
- retention
Period IntegerDays - The retention period for all the databases in this managed instance.
- transaction
Log IntegerBackup Minutes - The value indicating minutes between transaction log backups.
- differential
Backup numberHours - The differential backup interval in hours.
- full
Backup numberDays - The value indicating days between full backups.
- retention
Period numberDays - The retention period for all the databases in this managed instance.
- transaction
Log numberBackup Minutes - The value indicating minutes between transaction log backups.
- differential_
backup_ inthours - The differential backup interval in hours.
- full_
backup_ intdays - The value indicating days between full backups.
- retention_
period_ intdays - The retention period for all the databases in this managed instance.
- transaction_
log_ intbackup_ minutes - The value indicating minutes between transaction log backups.
- differential
Backup NumberHours - The differential backup interval in hours.
- full
Backup NumberDays - The value indicating days between full backups.
- retention
Period NumberDays - The retention period for all the databases in this managed instance.
- transaction
Log NumberBackup Minutes - The value indicating minutes between transaction log backups.
ClientConnectionResponse
- Enabled bool
- Indicates if client connection is enabled for this SQL Server instance.
- Enabled bool
- Indicates if client connection is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if client connection is enabled for this SQL Server instance.
- enabled boolean
- Indicates if client connection is enabled for this SQL Server instance.
- enabled bool
- Indicates if client connection is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if client connection is enabled for this SQL Server instance.
DBMEndpointResponse
- Certificate
Name string - Name of the certificate.
- Connection
Auth string - The type of connection authentication required for connections to this endpoint
- Encryption
Algorithm string - Encryption Algorithm
- Endpoint
Name string - Name of the database mirroring endpoint.
- Ip
Address string - Listener IP address.
- Is
Dynamic boolPort - Is the port number dynamically assigned.
- Is
Encryption boolEnabled - Is Encryption enabled
- Port int
- The port number that the endpoint is listening on.
- Role string
- Mirroring Role
- Certificate
Name string - Name of the certificate.
- Connection
Auth string - The type of connection authentication required for connections to this endpoint
- Encryption
Algorithm string - Encryption Algorithm
- Endpoint
Name string - Name of the database mirroring endpoint.
- Ip
Address string - Listener IP address.
- Is
Dynamic boolPort - Is the port number dynamically assigned.
- Is
Encryption boolEnabled - Is Encryption enabled
- Port int
- The port number that the endpoint is listening on.
- Role string
- Mirroring Role
- certificate
Name String - Name of the certificate.
- connection
Auth String - The type of connection authentication required for connections to this endpoint
- encryption
Algorithm String - Encryption Algorithm
- endpoint
Name String - Name of the database mirroring endpoint.
- ip
Address String - Listener IP address.
- is
Dynamic BooleanPort - Is the port number dynamically assigned.
- is
Encryption BooleanEnabled - Is Encryption enabled
- port Integer
- The port number that the endpoint is listening on.
- role String
- Mirroring Role
- certificate
Name string - Name of the certificate.
- connection
Auth string - The type of connection authentication required for connections to this endpoint
- encryption
Algorithm string - Encryption Algorithm
- endpoint
Name string - Name of the database mirroring endpoint.
- ip
Address string - Listener IP address.
- is
Dynamic booleanPort - Is the port number dynamically assigned.
- is
Encryption booleanEnabled - Is Encryption enabled
- port number
- The port number that the endpoint is listening on.
- role string
- Mirroring Role
- certificate_
name str - Name of the certificate.
- connection_
auth str - The type of connection authentication required for connections to this endpoint
- encryption_
algorithm str - Encryption Algorithm
- endpoint_
name str - Name of the database mirroring endpoint.
- ip_
address str - Listener IP address.
- is_
dynamic_ boolport - Is the port number dynamically assigned.
- is_
encryption_ boolenabled - Is Encryption enabled
- port int
- The port number that the endpoint is listening on.
- role str
- Mirroring Role
- certificate
Name String - Name of the certificate.
- connection
Auth String - The type of connection authentication required for connections to this endpoint
- encryption
Algorithm String - Encryption Algorithm
- endpoint
Name String - Name of the database mirroring endpoint.
- ip
Address String - Listener IP address.
- is
Dynamic BooleanPort - Is the port number dynamically assigned.
- is
Encryption BooleanEnabled - Is Encryption enabled
- port Number
- The port number that the endpoint is listening on.
- role String
- Mirroring Role
EntraAuthenticationResponse
- Client
Id string - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- Identity
Type string - The method used for Entra authentication
- Client
Id string - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- Identity
Type string - The method used for Entra authentication
- client
Id String - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- identity
Type String - The method used for Entra authentication
- client
Id string - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- identity
Type string - The method used for Entra authentication
- client_
id str - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- identity_
type str - The method used for Entra authentication
- client
Id String - The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.
- identity
Type String - The method used for Entra authentication
FailoverClusterResponse
- Host
IPAddresses List<Pulumi.Azure Native. Azure Arc Data. Inputs. Host IPAddress Information Response> - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- Host
Names List<string> - The host names which are part of the SQL FCI resource group.
- Id string
- The GUID of the SQL Server's underlying Failover Cluster.
- Network
Name string - The network name to connect to the SQL FCI.
- Sql
Instance List<string>Ids - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- Host
IPAddresses []HostIPAddress Information Response - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- Host
Names []string - The host names which are part of the SQL FCI resource group.
- Id string
- The GUID of the SQL Server's underlying Failover Cluster.
- Network
Name string - The network name to connect to the SQL FCI.
- Sql
Instance []stringIds - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
IPAddresses List<HostIPAddress Information Response> - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- host
Names List<String> - The host names which are part of the SQL FCI resource group.
- id String
- The GUID of the SQL Server's underlying Failover Cluster.
- network
Name String - The network name to connect to the SQL FCI.
- sql
Instance List<String>Ids - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
IPAddresses HostIPAddress Information Response[] - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- host
Names string[] - The host names which are part of the SQL FCI resource group.
- id string
- The GUID of the SQL Server's underlying Failover Cluster.
- network
Name string - The network name to connect to the SQL FCI.
- sql
Instance string[]Ids - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host_
ip_ Sequence[Hostaddresses IPAddress Information Response] - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- host_
names Sequence[str] - The host names which are part of the SQL FCI resource group.
- id str
- The GUID of the SQL Server's underlying Failover Cluster.
- network_
name str - The network name to connect to the SQL FCI.
- sql_
instance_ Sequence[str]ids - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
- host
IPAddresses List<Property Map> - The IP addresses and subnet masks associated with the SQL Failover Cluster Instance on this host.
- host
Names List<String> - The host names which are part of the SQL FCI resource group.
- id String
- The GUID of the SQL Server's underlying Failover Cluster.
- network
Name String - The network name to connect to the SQL FCI.
- sql
Instance List<String>Ids - The ARM IDs of the Arc SQL Server resources, belonging to the current server's Failover cluster.
HostIPAddressInformationResponse
- Ip
Address string - IP address
- Subnet
Mask string - Subnet mask
- Ip
Address string - IP address
- Subnet
Mask string - Subnet mask
- ip
Address String - IP address
- subnet
Mask String - Subnet mask
- ip
Address string - IP address
- subnet
Mask string - Subnet mask
- ip_
address str - IP address
- subnet_
mask str - Subnet mask
- ip
Address String - IP address
- subnet
Mask String - Subnet mask
MigrationAssessmentResponse
- Assessment
Upload stringTime - The time when Migration Assessment Report upload was last performed.
- Server
Assessments List<Pulumi.Azure Native. Azure Arc Data. Inputs. Migration Assessment Response Server Assessments> - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- Sku
Recommendation Pulumi.Results Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Response - SKU Recommendation results for Azure migration targets for SQL Server.
- Enabled bool
- Indicates if migration assessment is enabled for this SQL Server instance.
- Assessment
Upload stringTime - The time when Migration Assessment Report upload was last performed.
- Server
Assessments []MigrationAssessment Response Server Assessments - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- Sku
Recommendation SkuResults Recommendation Results Response - SKU Recommendation results for Azure migration targets for SQL Server.
- Enabled bool
- Indicates if migration assessment is enabled for this SQL Server instance.
- assessment
Upload StringTime - The time when Migration Assessment Report upload was last performed.
- server
Assessments List<MigrationAssessment Response Server Assessments> - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- sku
Recommendation SkuResults Recommendation Results Response - SKU Recommendation results for Azure migration targets for SQL Server.
- enabled Boolean
- Indicates if migration assessment is enabled for this SQL Server instance.
- assessment
Upload stringTime - The time when Migration Assessment Report upload was last performed.
- server
Assessments MigrationAssessment Response Server Assessments[] - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- sku
Recommendation SkuResults Recommendation Results Response - SKU Recommendation results for Azure migration targets for SQL Server.
- enabled boolean
- Indicates if migration assessment is enabled for this SQL Server instance.
- assessment_
upload_ strtime - The time when Migration Assessment Report upload was last performed.
- server_
assessments Sequence[MigrationAssessment Response Server Assessments] - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- sku_
recommendation_ Skuresults Recommendation Results Response - SKU Recommendation results for Azure migration targets for SQL Server.
- enabled bool
- Indicates if migration assessment is enabled for this SQL Server instance.
- assessment
Upload StringTime - The time when Migration Assessment Report upload was last performed.
- server
Assessments List<Property Map> - Issues and warnings impacting the migration of SQL Server instance to particular Azure Migration Target.
- sku
Recommendation Property MapResults - SKU Recommendation results for Azure migration targets for SQL Server.
- enabled Boolean
- Indicates if migration assessment is enabled for this SQL Server instance.
MigrationAssessmentResponseImpactedObjects
- Impact
Detail string - Name string
- Object
Type string
- Impact
Detail string - Name string
- Object
Type string
- impact
Detail String - name String
- object
Type String
- impact
Detail string - name string
- object
Type string
- impact_
detail str - name str
- object_
type str
- impact
Detail String - name String
- object
Type String
MigrationAssessmentResponseServerAssessments
- applies
To StringMigration Target Platform - feature
Id String - impacted
Objects List<Property Map> - issue
Category String - more
Information String
MigrationResponse
- Assessment
Pulumi.
Azure Native. Azure Arc Data. Inputs. Migration Assessment Response - Migration assessments related configuration.
- Assessment
Migration
Assessment Response - Migration assessments related configuration.
- assessment
Migration
Assessment Response - Migration assessments related configuration.
- assessment
Migration
Assessment Response - Migration assessments related configuration.
- assessment
Migration
Assessment Response - Migration assessments related configuration.
- assessment Property Map
- Migration assessments related configuration.
MonitoringResponse
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- Enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled boolean
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled bool
- Indicates if monitoring is enabled for this SQL Server instance.
- enabled Boolean
- Indicates if monitoring is enabled for this SQL Server instance.
SkuRecommendationResultsAzureSqlDatabaseResponse
- Monthly
Cost Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Database Response Target Sku
- Monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku SkuRecommendation Results Azure Sql Database Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of IntegerServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Database Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of numberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status string - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Database Response Target Sku
- monthly_
cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number_
of_ intserver_ blocker_ issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation_
status str - The target recommendation Status for this database.
- target_
sku SkuRecommendation Results Azure Sql Database Response Target Sku
- monthly
Cost Property Map - The Monthly cost of the particular SKU.
- number
Of NumberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku Property Map
SkuRecommendationResultsAzureSqlDatabaseResponseCategory
- Compute
Tier string - The compute tier of the target SKU.
- Hardware
Type string - The hardware type of the target SKU.
- Sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- Sql
Service stringTier - The SQL service tier of the target SKU.
- Zone
Redundancy boolAvailable - Indicates if zone redundancy is available for the target SKU.
- Compute
Tier string - The compute tier of the target SKU.
- Hardware
Type string - The hardware type of the target SKU.
- Sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- Sql
Service stringTier - The SQL service tier of the target SKU.
- Zone
Redundancy boolAvailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier String - The compute tier of the target SKU.
- hardware
Type String - The hardware type of the target SKU.
- sql
Purchasing StringModel - The SQL purchasing model of the target SKU.
- sql
Service StringTier - The SQL service tier of the target SKU.
- zone
Redundancy BooleanAvailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier string - The compute tier of the target SKU.
- hardware
Type string - The hardware type of the target SKU.
- sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- sql
Service stringTier - The SQL service tier of the target SKU.
- zone
Redundancy booleanAvailable - Indicates if zone redundancy is available for the target SKU.
- compute_
tier str - The compute tier of the target SKU.
- hardware_
type str - The hardware type of the target SKU.
- sql_
purchasing_ strmodel - The SQL purchasing model of the target SKU.
- sql_
service_ strtier - The SQL service tier of the target SKU.
- zone_
redundancy_ boolavailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier String - The compute tier of the target SKU.
- hardware
Type String - The hardware type of the target SKU.
- sql
Purchasing StringModel - The SQL purchasing model of the target SKU.
- sql
Service StringTier - The SQL service tier of the target SKU.
- zone
Redundancy BooleanAvailable - Indicates if zone redundancy is available for the target SKU.
SkuRecommendationResultsAzureSqlDatabaseResponseTargetSku
SkuRecommendationResultsAzureSqlManagedInstanceResponse
- Monthly
Cost Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Managed Instance Response Target Sku
- Monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku SkuRecommendation Results Azure Sql Managed Instance Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of IntegerServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Managed Instance Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of numberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status string - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Managed Instance Response Target Sku
- monthly_
cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number_
of_ intserver_ blocker_ issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation_
status str - The target recommendation Status for this database.
- target_
sku SkuRecommendation Results Azure Sql Managed Instance Response Target Sku
- monthly
Cost Property Map - The Monthly cost of the particular SKU.
- number
Of NumberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku Property Map
SkuRecommendationResultsAzureSqlManagedInstanceResponseCategory
- Compute
Tier string - The compute tier of the target SKU.
- Hardware
Type string - The hardware type of the target SKU.
- Sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- Sql
Service stringTier - The SQL service tier of the target SKU.
- Zone
Redundancy boolAvailable - Indicates if zone redundancy is available for the target SKU.
- Compute
Tier string - The compute tier of the target SKU.
- Hardware
Type string - The hardware type of the target SKU.
- Sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- Sql
Service stringTier - The SQL service tier of the target SKU.
- Zone
Redundancy boolAvailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier String - The compute tier of the target SKU.
- hardware
Type String - The hardware type of the target SKU.
- sql
Purchasing StringModel - The SQL purchasing model of the target SKU.
- sql
Service StringTier - The SQL service tier of the target SKU.
- zone
Redundancy BooleanAvailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier string - The compute tier of the target SKU.
- hardware
Type string - The hardware type of the target SKU.
- sql
Purchasing stringModel - The SQL purchasing model of the target SKU.
- sql
Service stringTier - The SQL service tier of the target SKU.
- zone
Redundancy booleanAvailable - Indicates if zone redundancy is available for the target SKU.
- compute_
tier str - The compute tier of the target SKU.
- hardware_
type str - The hardware type of the target SKU.
- sql_
purchasing_ strmodel - The SQL purchasing model of the target SKU.
- sql_
service_ strtier - The SQL service tier of the target SKU.
- zone_
redundancy_ boolavailable - Indicates if zone redundancy is available for the target SKU.
- compute
Tier String - The compute tier of the target SKU.
- hardware
Type String - The hardware type of the target SKU.
- sql
Purchasing StringModel - The SQL purchasing model of the target SKU.
- sql
Service StringTier - The SQL service tier of the target SKU.
- zone
Redundancy BooleanAvailable - Indicates if zone redundancy is available for the target SKU.
SkuRecommendationResultsAzureSqlManagedInstanceResponseTargetSku
SkuRecommendationResultsAzureSqlVirtualMachineResponse
- Monthly
Cost Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku Pulumi.Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Virtual Machine Response Target Sku
- Monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- Number
Of intServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- Recommendation
Status string - The target recommendation Status for this database.
- Target
Sku SkuRecommendation Results Azure Sql Virtual Machine Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of IntegerServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Virtual Machine Response Target Sku
- monthly
Cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number
Of numberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status string - The target recommendation Status for this database.
- target
Sku SkuRecommendation Results Azure Sql Virtual Machine Response Target Sku
- monthly_
cost SkuRecommendation Results Monthly Cost Response - The Monthly cost of the particular SKU.
- number_
of_ intserver_ blocker_ issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation_
status str - The target recommendation Status for this database.
- target_
sku SkuRecommendation Results Azure Sql Virtual Machine Response Target Sku
- monthly
Cost Property Map - The Monthly cost of the particular SKU.
- number
Of NumberServer Blocker Issues - Number of blocker issues to fix before migrating to the target platform.
- recommendation
Status String - The target recommendation Status for this database.
- target
Sku Property Map
SkuRecommendationResultsAzureSqlVirtualMachineResponseCategory
- Available
Vm List<string>Skus - Available VM SKUs for the Azure SQL Virtual Machine.
- Virtual
Machine stringFamily - The virtual machine family of the target SKU.
- Available
Vm []stringSkus - Available VM SKUs for the Azure SQL Virtual Machine.
- Virtual
Machine stringFamily - The virtual machine family of the target SKU.
- available
Vm List<String>Skus - Available VM SKUs for the Azure SQL Virtual Machine.
- virtual
Machine StringFamily - The virtual machine family of the target SKU.
- available
Vm string[]Skus - Available VM SKUs for the Azure SQL Virtual Machine.
- virtual
Machine stringFamily - The virtual machine family of the target SKU.
- available_
vm_ Sequence[str]skus - Available VM SKUs for the Azure SQL Virtual Machine.
- virtual_
machine_ strfamily - The virtual machine family of the target SKU.
- available
Vm List<String>Skus - Available VM SKUs for the Azure SQL Virtual Machine.
- virtual
Machine StringFamily - The virtual machine family of the target SKU.
SkuRecommendationResultsAzureSqlVirtualMachineResponseTargetSku
SkuRecommendationResultsMonthlyCostResponse
- Compute
Cost double - Represents the Cost of Compute.
- Storage
Cost double - Represents the Cost of Storage.
- Total
Cost double - Represents the Total Cost.
- Compute
Cost float64 - Represents the Cost of Compute.
- Storage
Cost float64 - Represents the Cost of Storage.
- Total
Cost float64 - Represents the Total Cost.
- compute
Cost Double - Represents the Cost of Compute.
- storage
Cost Double - Represents the Cost of Storage.
- total
Cost Double - Represents the Total Cost.
- compute
Cost number - Represents the Cost of Compute.
- storage
Cost number - Represents the Cost of Storage.
- total
Cost number - Represents the Total Cost.
- compute_
cost float - Represents the Cost of Compute.
- storage_
cost float - Represents the Cost of Storage.
- total_
cost float - Represents the Total Cost.
- compute
Cost Number - Represents the Cost of Compute.
- storage
Cost Number - Represents the Cost of Storage.
- total
Cost Number - Represents the Total Cost.
SkuRecommendationResultsResponse
- Azure
Sql Pulumi.Database Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Database Response - SKU Recommendation results for Azure SQL Database.
- Azure
Sql Pulumi.Managed Instance Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Managed Instance Response - SKU Recommendation results for Azure SQL Managed Instance.
- Azure
Sql Pulumi.Virtual Machine Azure Native. Azure Arc Data. Inputs. Sku Recommendation Results Azure Sql Virtual Machine Response - SKU Recommendation results for Azure SQL Virtual Machine.
- Azure
Sql SkuDatabase Recommendation Results Azure Sql Database Response - SKU Recommendation results for Azure SQL Database.
- Azure
Sql SkuManaged Instance Recommendation Results Azure Sql Managed Instance Response - SKU Recommendation results for Azure SQL Managed Instance.
- Azure
Sql SkuVirtual Machine Recommendation Results Azure Sql Virtual Machine Response - SKU Recommendation results for Azure SQL Virtual Machine.
- azure
Sql SkuDatabase Recommendation Results Azure Sql Database Response - SKU Recommendation results for Azure SQL Database.
- azure
Sql SkuManaged Instance Recommendation Results Azure Sql Managed Instance Response - SKU Recommendation results for Azure SQL Managed Instance.
- azure
Sql SkuVirtual Machine Recommendation Results Azure Sql Virtual Machine Response - SKU Recommendation results for Azure SQL Virtual Machine.
- azure
Sql SkuDatabase Recommendation Results Azure Sql Database Response - SKU Recommendation results for Azure SQL Database.
- azure
Sql SkuManaged Instance Recommendation Results Azure Sql Managed Instance Response - SKU Recommendation results for Azure SQL Managed Instance.
- azure
Sql SkuVirtual Machine Recommendation Results Azure Sql Virtual Machine Response - SKU Recommendation results for Azure SQL Virtual Machine.
- azure_
sql_ Skudatabase Recommendation Results Azure Sql Database Response - SKU Recommendation results for Azure SQL Database.
- azure_
sql_ Skumanaged_ instance Recommendation Results Azure Sql Managed Instance Response - SKU Recommendation results for Azure SQL Managed Instance.
- azure_
sql_ Skuvirtual_ machine Recommendation Results Azure Sql Virtual Machine Response - SKU Recommendation results for Azure SQL Virtual Machine.
- azure
Sql Property MapDatabase - SKU Recommendation results for Azure SQL Database.
- azure
Sql Property MapManaged Instance - SKU Recommendation results for Azure SQL Managed Instance.
- azure
Sql Property MapVirtual Machine - SKU Recommendation results for Azure SQL Virtual Machine.
SqlServerInstancePropertiesResponse
- Always
On stringRole - The role of the SQL Server, based on availability.
- Azure
Defender stringStatus - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time string - The time when the resource was created.
- Current
Version string - SQL Server current version.
- Db
Master boolKey Exists - Indicates whether database master key exists in SQL Server.
- Is
Digi boolCert Pki Cert Trust Configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- Is
Hadr boolEnabled - Indicates whether always On availability groups is enabled in SQL Server.
- Is
Microsoft boolPki Cert Trust Configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- Last
Inventory stringUpload Time - The time when last successful inventory upload was performed.
- Last
Usage stringUpload Time - The time when last successful usage upload was performed.
- License
Type string - SQL Server license type.
- Max
Server doubleMemory MB - max server memory (MB) value configured for this instance.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - Static TCP ports used by SQL Server.
- Trace
Flags List<int> - An array of integers, where each value represents the enabled trace flags in SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Vm
Id string - The unique ID of the hybrid machine that this resource belongs to.
- Authentication
Pulumi.
Azure Native. Azure Arc Data. Inputs. Authentication Response - Authentication related configuration for the SQL Server Instance.
- Backup
Policy Pulumi.Azure Native. Azure Arc Data. Inputs. Backup Policy Response - The backup profile for the SQL server.
- Client
Connection Pulumi.Azure Native. Azure Arc Data. Inputs. Client Connection Response - Client connection related configuration.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Database
Mirroring Pulumi.Endpoint Azure Native. Azure Arc Data. Inputs. DBMEndpoint Response - Database mirroring endpoint related properties.
- Edition string
- SQL Server edition.
- Failover
Cluster Pulumi.Azure Native. Azure Arc Data. Inputs. Failover Cluster Response - Failover Cluster Instance properties.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Migration
Pulumi.
Azure Native. Azure Arc Data. Inputs. Migration Response - Migration related configuration.
- Monitoring
Pulumi.
Azure Native. Azure Arc Data. Inputs. Monitoring Response - The monitoring configuration.
- Service
Type string - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- Upgrade
Locked stringUntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- Version string
- SQL Server version.
- Always
On stringRole - The role of the SQL Server, based on availability.
- Azure
Defender stringStatus - Status of Azure Defender.
- Azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- Create
Time string - The time when the resource was created.
- Current
Version string - SQL Server current version.
- Db
Master boolKey Exists - Indicates whether database master key exists in SQL Server.
- Is
Digi boolCert Pki Cert Trust Configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- Is
Hadr boolEnabled - Indicates whether always On availability groups is enabled in SQL Server.
- Is
Microsoft boolPki Cert Trust Configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- Last
Inventory stringUpload Time - The time when last successful inventory upload was performed.
- Last
Usage stringUpload Time - The time when last successful usage upload was performed.
- License
Type string - SQL Server license type.
- Max
Server float64Memory MB - max server memory (MB) value configured for this instance.
- Patch
Level string - SQL Server update level.
- Product
Id string - SQL Server product ID.
- Provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- Tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- Tcp
Static stringPorts - Static TCP ports used by SQL Server.
- Trace
Flags []int - An array of integers, where each value represents the enabled trace flags in SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Vm
Id string - The unique ID of the hybrid machine that this resource belongs to.
- Authentication
Authentication
Response - Authentication related configuration for the SQL Server Instance.
- Backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- Client
Connection ClientConnection Response - Client connection related configuration.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- Database
Mirroring DBMEndpointEndpoint Response - Database mirroring endpoint related properties.
- Edition string
- SQL Server edition.
- Failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- Host
Type string - Type of host for Azure Arc SQL Server
- Instance
Name string - SQL Server instance name.
- Migration
Migration
Response - Migration related configuration.
- Monitoring
Monitoring
Response - The monitoring configuration.
- Service
Type string - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- Upgrade
Locked stringUntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- Version string
- SQL Server version.
- always
On StringRole - The role of the SQL Server, based on availability.
- azure
Defender StringStatus - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- container
Resource StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time String - The time when the resource was created.
- current
Version String - SQL Server current version.
- db
Master BooleanKey Exists - Indicates whether database master key exists in SQL Server.
- is
Digi BooleanCert Pki Cert Trust Configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- is
Hadr BooleanEnabled - Indicates whether always On availability groups is enabled in SQL Server.
- is
Microsoft BooleanPki Cert Trust Configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- last
Inventory StringUpload Time - The time when last successful inventory upload was performed.
- last
Usage StringUpload Time - The time when last successful usage upload was performed.
- license
Type String - SQL Server license type.
- max
Server DoubleMemory MB - max server memory (MB) value configured for this instance.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- trace
Flags List<Integer> - An array of integers, where each value represents the enabled trace flags in SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- vm
Id String - The unique ID of the hybrid machine that this resource belongs to.
- authentication
Authentication
Response - Authentication related configuration for the SQL Server Instance.
- backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- client
Connection ClientConnection Response - Client connection related configuration.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- database
Mirroring DBMEndpointEndpoint Response - Database mirroring endpoint related properties.
- edition String
- SQL Server edition.
- failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- migration
Migration
Response - Migration related configuration.
- monitoring
Monitoring
Response - The monitoring configuration.
- service
Type String - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- upgrade
Locked StringUntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- version String
- SQL Server version.
- always
On stringRole - The role of the SQL Server, based on availability.
- azure
Defender stringStatus - Status of Azure Defender.
- azure
Defender stringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation string
- SQL Server collation.
- container
Resource stringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time string - The time when the resource was created.
- current
Version string - SQL Server current version.
- db
Master booleanKey Exists - Indicates whether database master key exists in SQL Server.
- is
Digi booleanCert Pki Cert Trust Configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- is
Hadr booleanEnabled - Indicates whether always On availability groups is enabled in SQL Server.
- is
Microsoft booleanPki Cert Trust Configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- last
Inventory stringUpload Time - The time when last successful inventory upload was performed.
- last
Usage stringUpload Time - The time when last successful usage upload was performed.
- license
Type string - SQL Server license type.
- max
Server numberMemory MB - max server memory (MB) value configured for this instance.
- patch
Level string - SQL Server update level.
- product
Id string - SQL Server product ID.
- provisioning
State string - The provisioning state of the Arc-enabled SQL Server resource.
- status string
- The cloud connectivity status.
- tcp
Dynamic stringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static stringPorts - Static TCP ports used by SQL Server.
- trace
Flags number[] - An array of integers, where each value represents the enabled trace flags in SQL Server.
- v
Core string - The number of logical processors used by the SQL Server instance.
- vm
Id string - The unique ID of the hybrid machine that this resource belongs to.
- authentication
Authentication
Response - Authentication related configuration for the SQL Server Instance.
- backup
Policy BackupPolicy Response - The backup profile for the SQL server.
- client
Connection ClientConnection Response - Client connection related configuration.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- database
Mirroring DBMEndpointEndpoint Response - Database mirroring endpoint related properties.
- edition string
- SQL Server edition.
- failover
Cluster FailoverCluster Response - Failover Cluster Instance properties.
- host
Type string - Type of host for Azure Arc SQL Server
- instance
Name string - SQL Server instance name.
- migration
Migration
Response - Migration related configuration.
- monitoring
Monitoring
Response - The monitoring configuration.
- service
Type string - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- upgrade
Locked stringUntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- version string
- SQL Server version.
- always_
on_ strrole - The role of the SQL Server, based on availability.
- azure_
defender_ strstatus - Status of Azure Defender.
- azure_
defender_ strstatus_ last_ updated - Timestamp of last Azure Defender status update.
- collation str
- SQL Server collation.
- container_
resource_ strid - ARM Resource id of the container resource (Azure Arc for Servers).
- create_
time str - The time when the resource was created.
- current_
version str - SQL Server current version.
- db_
master_ boolkey_ exists - Indicates whether database master key exists in SQL Server.
- is_
digi_ boolcert_ pki_ cert_ trust_ configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- is_
hadr_ boolenabled - Indicates whether always On availability groups is enabled in SQL Server.
- is_
microsoft_ boolpki_ cert_ trust_ configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- last_
inventory_ strupload_ time - The time when last successful inventory upload was performed.
- last_
usage_ strupload_ time - The time when last successful usage upload was performed.
- license_
type str - SQL Server license type.
- max_
server_ floatmemory_ mb - max server memory (MB) value configured for this instance.
- patch_
level str - SQL Server update level.
- product_
id str - SQL Server product ID.
- provisioning_
state str - The provisioning state of the Arc-enabled SQL Server resource.
- status str
- The cloud connectivity status.
- tcp_
dynamic_ strports - Dynamic TCP ports used by SQL Server.
- tcp_
static_ strports - Static TCP ports used by SQL Server.
- trace_
flags Sequence[int] - An array of integers, where each value represents the enabled trace flags in SQL Server.
- v_
core str - The number of logical processors used by the SQL Server instance.
- vm_
id str - The unique ID of the hybrid machine that this resource belongs to.
- authentication
Authentication
Response - Authentication related configuration for the SQL Server Instance.
- backup_
policy BackupPolicy Response - The backup profile for the SQL server.
- client_
connection ClientConnection Response - Client connection related configuration.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- database_
mirroring_ DBMEndpointendpoint Response - Database mirroring endpoint related properties.
- edition str
- SQL Server edition.
- failover_
cluster FailoverCluster Response - Failover Cluster Instance properties.
- host_
type str - Type of host for Azure Arc SQL Server
- instance_
name str - SQL Server instance name.
- migration
Migration
Response - Migration related configuration.
- monitoring
Monitoring
Response - The monitoring configuration.
- service_
type str - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- upgrade_
locked_ struntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- version str
- SQL Server version.
- always
On StringRole - The role of the SQL Server, based on availability.
- azure
Defender StringStatus - Status of Azure Defender.
- azure
Defender StringStatus Last Updated - Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- container
Resource StringId - ARM Resource id of the container resource (Azure Arc for Servers).
- create
Time String - The time when the resource was created.
- current
Version String - SQL Server current version.
- db
Master BooleanKey Exists - Indicates whether database master key exists in SQL Server.
- is
Digi BooleanCert Pki Cert Trust Configured - Indicates whether DigiCert PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- is
Hadr BooleanEnabled - Indicates whether always On availability groups is enabled in SQL Server.
- is
Microsoft BooleanPki Cert Trust Configured - Indicates whether Microsoft PKI root-authority certificate (trusted by Azure) exists in SQL Server and trusted for Azure database.windows.net domains.
- last
Inventory StringUpload Time - The time when last successful inventory upload was performed.
- last
Usage StringUpload Time - The time when last successful usage upload was performed.
- license
Type String - SQL Server license type.
- max
Server NumberMemory MB - max server memory (MB) value configured for this instance.
- patch
Level String - SQL Server update level.
- product
Id String - SQL Server product ID.
- provisioning
State String - The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- tcp
Dynamic StringPorts - Dynamic TCP ports used by SQL Server.
- tcp
Static StringPorts - Static TCP ports used by SQL Server.
- trace
Flags List<Number> - An array of integers, where each value represents the enabled trace flags in SQL Server.
- v
Core String - The number of logical processors used by the SQL Server instance.
- vm
Id String - The unique ID of the hybrid machine that this resource belongs to.
- authentication Property Map
- Authentication related configuration for the SQL Server Instance.
- backup
Policy Property Map - The backup profile for the SQL server.
- client
Connection Property Map - Client connection related configuration.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- database
Mirroring Property MapEndpoint - Database mirroring endpoint related properties.
- edition String
- SQL Server edition.
- failover
Cluster Property Map - Failover Cluster Instance properties.
- host
Type String - Type of host for Azure Arc SQL Server
- instance
Name String - SQL Server instance name.
- migration Property Map
- Migration related configuration.
- monitoring Property Map
- The monitoring configuration.
- service
Type String - Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.
- upgrade
Locked StringUntil - Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.
- version String
- SQL Server version.
SystemDataResponse
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- Created
At string - The timestamp of resource creation (UTC).
- Created
By string - The identity that created the resource.
- Created
By stringType - The type of identity that created the resource.
- Last
Modified stringAt - The timestamp of resource last modification (UTC)
- Last
Modified stringBy - The identity that last modified the resource.
- Last
Modified stringBy Type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
- created
At string - The timestamp of resource creation (UTC).
- created
By string - The identity that created the resource.
- created
By stringType - The type of identity that created the resource.
- last
Modified stringAt - The timestamp of resource last modification (UTC)
- last
Modified stringBy - The identity that last modified the resource.
- last
Modified stringBy Type - The type of identity that last modified the resource.
- created_
at str - The timestamp of resource creation (UTC).
- created_
by str - The identity that created the resource.
- created_
by_ strtype - The type of identity that created the resource.
- last_
modified_ strat - The timestamp of resource last modification (UTC)
- last_
modified_ strby - The identity that last modified the resource.
- last_
modified_ strby_ type - The type of identity that last modified the resource.
- created
At String - The timestamp of resource creation (UTC).
- created
By String - The identity that created the resource.
- created
By StringType - The type of identity that created the resource.
- last
Modified StringAt - The timestamp of resource last modification (UTC)
- last
Modified StringBy - The identity that last modified the resource.
- last
Modified StringBy Type - The type of identity that last modified the resource.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0
