MSSQLDatabase is the Schema for the MSSQLDatabases API. Manages a MS SQL Database.
Type
CRD
Group
sql.azure.upbound.io
Version
v1beta1
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
MSSQLDatabaseSpec defines the desired state of MSSQLDatabase
No description provided.
A Database Import block as documented below. Mutually exclusive with create_mode.
A long_term_retention_policy block as defined below.
Reference to a MSSQLServer to populate serverId.
Policies for referencing.
Selector for a MSSQLServer to populate serverId.
Policies for selection.
A short_term_retention_policy block as defined below.
Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
A list of email addresses which alerts should be sent to.
THIS IS AN ALPHA FIELD. Do not use it in production. It is not honored unless the relevant Crossplane feature flag is enabled, and may be changed or removed without notice. InitProvider holds the same fields as ForProvider, with the exception of Identifier and other resource reference fields. The fields that are in InitProvider are merged into ForProvider when the resource is created. The same fields are also added to the terraform ignore_changes hook, to avoid updating them after creation. This is useful for fields that are required on creation, but we do not desire to update them after creation, for example because of an external controller is managing them, like an autoscaler.
A Database Import block as documented below. Mutually exclusive with create_mode.
A long_term_retention_policy block as defined below.
A short_term_retention_policy block as defined below.
Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
A list of email addresses which alerts should be sent to.
THIS IS AN ALPHA FIELD. Do not use it in production. It is not honored unless the relevant Crossplane feature flag is enabled, and may be changed or removed without notice. ManagementPolicies specify the array of actions Crossplane is allowed to take on the managed and external resources. This field is planned to replace the DeletionPolicy field in a future release. Currently, both could be set independently and non-default values would be honored if the feature flag is enabled. If both are custom, the DeletionPolicy field will be ignored. See the design doc for more information: https://github.com/crossplane/crossplane/blob/499895a25d1a1a0ba1604944ef98ac7a1a71f197/design/design-doc-observe-only-resources.md?plain=1#L223 and this one: https://github.com/crossplane/crossplane/blob/444267e84783136daa93568b364a5f01228cacbe/design/one-pager-ignore-changes.md
ProviderConfigReference specifies how the provider that will be used to create, observe, update, and delete this managed resource should be configured.
Policies for referencing.
ProviderReference specifies the provider that will be used to create, observe, update, and delete this managed resource. Deprecated: Please use ProviderConfigReference, i.e. providerConfigRef
Policies for referencing.
PublishConnectionDetailsTo specifies the connection secret config which contains a name, metadata and a reference to secret store config to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource.
WriteConnectionSecretToReference specifies the namespace and name of a Secret to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource. This field is planned to be replaced in a future release in favor of PublishConnectionDetailsTo. Currently, both could be set independently and connection details would be published to both without affecting each other.
MSSQLDatabaseStatus defines the observed state of MSSQLDatabase.
No description provided.
A Database Import block as documented below. Mutually exclusive with create_mode.
A long_term_retention_policy block as defined below.
A short_term_retention_policy block as defined below.
Threat detection policy configuration. The threat_detection_policy block supports fields documented below.
Specifies a list of alerts which should be disabled. Possible values include Access_Anomaly, Sql_Injection and Sql_Injection_Vulnerability.
A list of email addresses which alerts should be sent to.
Conditions of the resource.
mssqljobcred-db
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqljobcredential
uptest.upbound.io/timeout: "3600"
labels:
testing.upbound.io/example-name: mssqljobcred-db
name: mssqljobcred-db
spec:
forProvider:
collation: SQL_Latin1_General_CP1_CI_AS
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: mssqljobcred-srv
skuName: S1
mssqljobagent-db
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqljobagent
uptest.upbound.io/timeout: "3600"
labels:
testing.upbound.io/example-name: mssqljobagent-db
name: mssqljobagent-db
spec:
forProvider:
collation: SQL_Latin1_General_CP1_CI_AS
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: mssqljobagent-srv
skuName: S1
refinputmssql-sqldb
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: streamanalytics/v1beta1/referenceinputmssql
labels:
testing.upbound.io/example-name: refinputmssql-sqldb
name: refinputmssql-sqldb
spec:
forProvider:
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: refinputmssql-sqlsrv
example-failover
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqlfailovergroup
labels:
testing.upbound.io/example-name: example-failover
name: example-failover
spec:
forProvider:
collation: SQL_Latin1_General_CP1_CI_AS
maxSizeGb: 200
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: primary
skuName: S1
dbrulebaseline-db
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqldatabasevulnerabilityassessmentrulebaseline
upjet.upbound.io/manual-intervention: Requires existing blob storage path and key
labels:
testing.upbound.io/example-name: dbrulebaseline-db
name: dbrulebaseline-db
spec:
forProvider:
collation: SQL_Latin1_General_CP1_CI_AS
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: dbrulebaseline-srv
skuName: S1
database
apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
annotations:
meta.upbound.io/example-id: sql/v1beta1/mssqldatabaseextendedauditingpolicy
labels:
testing.upbound.io/example-name: example
name: database
spec:
forProvider:
serverIdSelector:
matchLabels:
testing.upbound.io/example-name: example
© 2022 Upbound, Inc.
Discover the building blocksfor your internal cloud platform.