SqlDatabaseResource Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A class representing a SqlDatabase along with the instance operations that can be performed on it. If you have a ResourceIdentifier you can construct a SqlDatabaseResource from an instance of ArmClient using the GetResource method. Otherwise you can get one from its parent resource SqlServerResource using the GetSqlDatabases method.
public class SqlDatabaseResource : Azure.ResourceManager.ArmResource, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.Sql.SqlDatabaseData>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.Sql.SqlDatabaseData>
type SqlDatabaseResource = class
inherit ArmResource
interface IJsonModel<SqlDatabaseData>
interface IPersistableModel<SqlDatabaseData>
Public Class SqlDatabaseResource
Inherits ArmResource
Implements IJsonModel(Of SqlDatabaseData), IPersistableModel(Of SqlDatabaseData)
- Inheritance
- Implements
Constructors
| Name | Description |
|---|---|
| SqlDatabaseResource() |
Initializes a new instance of SqlDatabaseResource for mocking. |
Fields
| Name | Description |
|---|---|
| ResourceType |
Gets the resource type for the operations. |
Properties
| Name | Description |
|---|---|
| Client |
Gets the ArmClient this resource client was created from. (Inherited from ArmResource) |
| Data |
Gets the data representing this Feature. |
| Diagnostics |
Gets the diagnostic options for this resource client. (Inherited from ArmResource) |
| Endpoint |
Gets the base uri for this resource client. (Inherited from ArmResource) |
| HasData |
Gets whether or not the current instance has data. |
| Id |
Gets the resource identifier. (Inherited from ArmResource) |
| Pipeline |
Gets the pipeline for this resource client. (Inherited from ArmResource) |
Methods
| Name | Description |
|---|---|
| AddTag(String, String, CancellationToken) |
Add a tag to the current resource. |
| AddTagAsync(String, String, CancellationToken) |
Add a tag to the current resource. |
| CancelDatabaseOperation(Guid, CancellationToken) |
Cancels the asynchronous operation on the database.
|
| CancelDatabaseOperationAsync(Guid, CancellationToken) |
Cancels the asynchronous operation on the database.
|
| CanUseTagResource(CancellationToken) |
Checks to see if the TagResource API is deployed in the current environment. (Inherited from ArmResource) |
| CanUseTagResourceAsync(CancellationToken) |
Checks to see if the TagResource API is deployed in the current environment. (Inherited from ArmResource) |
| CreateOrUpdateDatabaseExtension(WaitUntil, String, SqlDatabaseExtension, CancellationToken) |
Perform a database extension operation, like database import, database export, or polybase import
|
| CreateOrUpdateDatabaseExtensionAsync(WaitUntil, String, SqlDatabaseExtension, CancellationToken) |
Perform a database extension operation, like database import, database export, or polybase import
|
| CreateResourceIdentifier(String, String, String, String) |
Generate the resource identifier for this resource. |
| CreateRestorePoint(WaitUntil, CreateDatabaseRestorePointDefinition, CancellationToken) |
Creates a restore point for a data warehouse.
|
| CreateRestorePointAsync(WaitUntil, CreateDatabaseRestorePointDefinition, CancellationToken) |
Creates a restore point for a data warehouse.
|
| Delete(WaitUntil, CancellationToken) |
Deletes the database.
|
| DeleteAsync(WaitUntil, CancellationToken) |
Deletes the database.
|
| Export(WaitUntil, DatabaseExportDefinition, CancellationToken) |
Exports a database.
|
| ExportAsync(WaitUntil, DatabaseExportDefinition, CancellationToken) |
Exports a database.
|
| Failover(WaitUntil, Nullable<ReplicaType>, CancellationToken) |
Failovers a database.
|
| FailoverAsync(WaitUntil, Nullable<ReplicaType>, CancellationToken) |
Failovers a database.
|
| Get(String, String, CancellationToken) |
Gets a database.
|
| GetAsync(String, String, CancellationToken) |
Gets a database.
|
| GetAvailableLocations(CancellationToken) |
Lists all available geo-locations. (Inherited from ArmResource) |
| GetAvailableLocationsAsync(CancellationToken) |
Lists all available geo-locations. (Inherited from ArmResource) |
| GetBackupShortTermRetentionPolicies() |
Gets a collection of BackupShortTermRetentionPolicies in the SqlDatabaseResource. |
| GetBackupShortTermRetentionPolicy(ShortTermRetentionPolicyName, CancellationToken) |
Gets a database's short term retention policy. |
| GetBackupShortTermRetentionPolicyAsync(ShortTermRetentionPolicyName, CancellationToken) |
Gets a database's short term retention policy. |
| GetCurrentSensitivityLabels(String, Nullable<Boolean>, String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetCurrentSensitivityLabelsAsync(String, Nullable<Boolean>, String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetDatabaseAdvancedThreatProtection(AdvancedThreatProtectionName, CancellationToken) |
Gets a database's Advanced Threat Protection state. |
| GetDatabaseAdvancedThreatProtectionAsync(AdvancedThreatProtectionName, CancellationToken) |
Gets a database's Advanced Threat Protection state. |
| GetDatabaseAdvancedThreatProtections() |
Gets a collection of DatabaseAdvancedThreatProtections in the SqlDatabaseResource. |
| GetDatabaseColumns(IEnumerable<String>, IEnumerable<String>, IEnumerable<String>, IEnumerable<String>, String, CancellationToken) |
List database columns
|
| GetDatabaseColumnsAsync(IEnumerable<String>, IEnumerable<String>, IEnumerable<String>, IEnumerable<String>, String, CancellationToken) |
List database columns
|
| GetDatabaseExtensions(CancellationToken) |
List database extension. This will return an empty list as it is not supported.
|
| GetDatabaseExtensionsAsync(CancellationToken) |
List database extension. This will return an empty list as it is not supported.
|
| GetDatabaseOperations(CancellationToken) |
Gets a list of operations performed on the database.
|
| GetDatabaseOperationsAsync(CancellationToken) |
Gets a list of operations performed on the database.
|
| GetDatabaseUsages(CancellationToken) |
Gets database usages.
|
| GetDatabaseUsagesAsync(CancellationToken) |
Gets database usages.
|
| GetDataMaskingPolicies() |
Gets a collection of DataMaskingPolicies in the SqlDatabaseResource. |
| GetDataMaskingPolicy(DataMaskingPolicyName, CancellationToken) |
Gets the database data masking policy. |
| GetDataMaskingPolicyAsync(DataMaskingPolicyName, CancellationToken) |
Gets the database data masking policy. |
| GetDataWarehouseUserActivities() |
Gets a collection of DataWarehouseUserActivities in the SqlDatabaseResource. |
| GetDataWarehouseUserActivity(DataWarehouseUserActivityName, CancellationToken) |
Gets the user activities of a data warehouse which includes running and suspended queries. |
| GetDataWarehouseUserActivityAsync(DataWarehouseUserActivityName, CancellationToken) |
Gets the user activities of a data warehouse which includes running and suspended queries. |
| GetExtendedDatabaseBlobAuditingPolicies() |
Gets a collection of ExtendedDatabaseBlobAuditingPolicies in the SqlDatabaseResource. |
| GetExtendedDatabaseBlobAuditingPolicy(BlobAuditingPolicyName, CancellationToken) |
Gets an extended database's blob auditing policy. |
| GetExtendedDatabaseBlobAuditingPolicyAsync(BlobAuditingPolicyName, CancellationToken) |
Gets an extended database's blob auditing policy. |
| GetGeoBackupPolicies() |
Gets a collection of GeoBackupPolicies in the SqlDatabaseResource. |
| GetGeoBackupPolicy(GeoBackupPolicyName, CancellationToken) |
Gets a Geo backup policy for the given database resource. |
| GetGeoBackupPolicyAsync(GeoBackupPolicyName, CancellationToken) |
Gets a Geo backup policy for the given database resource. |
| GetLedgerDigestUpload(LedgerDigestUploadsName, CancellationToken) |
Gets the current ledger digest upload configuration for a database. |
| GetLedgerDigestUploadAsync(LedgerDigestUploadsName, CancellationToken) |
Gets the current ledger digest upload configuration for a database. |
| GetLedgerDigestUploads() |
Gets a collection of LedgerDigestUploads in the SqlDatabaseResource. |
| GetLogicalDatabaseTransparentDataEncryption(TransparentDataEncryptionName, CancellationToken) |
Gets a logical database's transparent data encryption. |
| GetLogicalDatabaseTransparentDataEncryptionAsync(TransparentDataEncryptionName, CancellationToken) |
Gets a logical database's transparent data encryption. |
| GetLogicalDatabaseTransparentDataEncryptions() |
Gets a collection of LogicalDatabaseTransparentDataEncryptions in the SqlDatabaseResource. |
| GetLongTermRetentionPolicies() |
Gets a collection of LongTermRetentionPolicies in the SqlDatabaseResource. |
| GetLongTermRetentionPolicy(LongTermRetentionPolicyName, CancellationToken) |
Gets a database's long term retention policy. |
| GetLongTermRetentionPolicyAsync(LongTermRetentionPolicyName, CancellationToken) |
Gets a database's long term retention policy. |
| GetMaintenanceWindowOption() |
Gets an object representing a MaintenanceWindowOptionResource along with the instance operations that can be performed on it in the SqlDatabaseResource. |
| GetMaintenanceWindows() |
Gets an object representing a MaintenanceWindowsResource along with the instance operations that can be performed on it in the SqlDatabaseResource. |
| GetManagementLock(String, CancellationToken) |
Get a management lock by scope.
|
| GetManagementLockAsync(String, CancellationToken) |
Get a management lock by scope.
|
| GetManagementLocks() |
Gets a collection of ManagementLockResources in the ArmResource. (Inherited from ArmResource) |
| GetPolicyAssignment(String, CancellationToken) |
This operation retrieves a single policy assignment, given its name and the scope it was created at.
|
| GetPolicyAssignmentAsync(String, CancellationToken) |
This operation retrieves a single policy assignment, given its name and the scope it was created at.
|
| GetPolicyAssignments() |
Gets a collection of PolicyAssignmentResources in the ArmResource. (Inherited from ArmResource) |
| GetRecommendedSensitivityLabels(String, Nullable<Boolean>, String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetRecommendedSensitivityLabelsAsync(String, Nullable<Boolean>, String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetSensitivityLabels(String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetSensitivityLabelsAsync(String, CancellationToken) |
Gets the sensitivity labels of a given database
|
| GetSqlDatabaseAdvisor(String, CancellationToken) |
Gets a database advisor. |
| GetSqlDatabaseAdvisorAsync(String, CancellationToken) |
Gets a database advisor. |
| GetSqlDatabaseAdvisors() |
Gets a collection of SqlDatabaseAdvisors in the SqlDatabaseResource. |
| GetSqlDatabaseAutomaticTuning() |
Gets an object representing a SqlDatabaseAutomaticTuningResource along with the instance operations that can be performed on it in the SqlDatabaseResource. |
| GetSqlDatabaseBlobAuditingPolicies() |
Gets a collection of SqlDatabaseBlobAuditingPolicies in the SqlDatabaseResource. |
| GetSqlDatabaseBlobAuditingPolicy(BlobAuditingPolicyName, CancellationToken) |
Gets a database's blob auditing policy. |
| GetSqlDatabaseBlobAuditingPolicyAsync(BlobAuditingPolicyName, CancellationToken) |
Gets a database's blob auditing policy. |
| GetSqlDatabaseSchema(String, CancellationToken) |
Get database schema. |
| GetSqlDatabaseSchemaAsync(String, CancellationToken) |
Get database schema. |
| GetSqlDatabaseSchemas() |
Gets a collection of SqlDatabaseSchemas in the SqlDatabaseResource. |
| GetSqlDatabaseSecurityAlertPolicies() |
Gets a collection of SqlDatabaseSecurityAlertPolicies in the SqlDatabaseResource. |
| GetSqlDatabaseSecurityAlertPolicy(SqlSecurityAlertPolicyName, CancellationToken) |
Gets a database's security alert policy. |
| GetSqlDatabaseSecurityAlertPolicyAsync(SqlSecurityAlertPolicyName, CancellationToken) |
Gets a database's security alert policy. |
| GetSqlDatabaseSqlVulnerabilityAssessment(VulnerabilityAssessmentName, CancellationToken) |
Gets SQL Vulnerability Assessment policy for database. |
| GetSqlDatabaseSqlVulnerabilityAssessmentAsync(VulnerabilityAssessmentName, CancellationToken) |
Gets SQL Vulnerability Assessment policy for database. |
| GetSqlDatabaseSqlVulnerabilityAssessments() |
Gets a collection of SqlDatabaseSqlVulnerabilityAssessments in the SqlDatabaseResource. |
| GetSqlDatabaseVulnerabilityAssessment(VulnerabilityAssessmentName, CancellationToken) |
Gets the database's vulnerability assessment. |
| GetSqlDatabaseVulnerabilityAssessmentAsync(VulnerabilityAssessmentName, CancellationToken) |
Gets the database's vulnerability assessment. |
| GetSqlDatabaseVulnerabilityAssessments() |
Gets a collection of SqlDatabaseVulnerabilityAssessments in the SqlDatabaseResource. |
| GetSqlServerDatabaseReplicationLink(String, CancellationToken) |
Gets a replication link. |
| GetSqlServerDatabaseReplicationLinkAsync(String, CancellationToken) |
Gets a replication link. |
| GetSqlServerDatabaseReplicationLinks() |
Gets a collection of SqlServerDatabaseReplicationLinks in the SqlDatabaseResource. |
| GetSqlServerDatabaseRestorePoint(String, CancellationToken) |
Gets a restore point. |
| GetSqlServerDatabaseRestorePointAsync(String, CancellationToken) |
Gets a restore point. |
| GetSqlServerDatabaseRestorePoints() |
Gets a collection of SqlServerDatabaseRestorePoints in the SqlDatabaseResource. |
| GetSynapseLinkWorkspaces(CancellationToken) |
Gets all synapselink workspaces for a database.
|
| GetSynapseLinkWorkspacesAsync(CancellationToken) |
Gets all synapselink workspaces for a database.
|
| GetSyncGroup(String, CancellationToken) |
Gets a sync group. |
| GetSyncGroupAsync(String, CancellationToken) |
Gets a sync group. |
| GetSyncGroups() |
Gets a collection of SyncGroups in the SqlDatabaseResource. |
| GetTagResource() |
Gets an object representing a TagResource along with the instance operations that can be performed on it in the ArmResource. (Inherited from ArmResource) |
| GetWorkloadGroup(String, CancellationToken) |
Gets a workload group. |
| GetWorkloadGroupAsync(String, CancellationToken) |
Gets a workload group. |
| GetWorkloadGroups() |
Gets a collection of WorkloadGroups in the SqlDatabaseResource. |
| Import(WaitUntil, ImportExistingDatabaseDefinition, CancellationToken) |
Imports a bacpac into a new database.
|
| ImportAsync(WaitUntil, ImportExistingDatabaseDefinition, CancellationToken) |
Imports a bacpac into a new database.
|
| Pause(WaitUntil, CancellationToken) |
Pauses a database.
|
| PauseAsync(WaitUntil, CancellationToken) |
Pauses a database.
|
| RemoveTag(String, CancellationToken) |
Removes a tag by key from the resource. |
| RemoveTagAsync(String, CancellationToken) |
Removes a tag by key from the resource. |
| Rename(SqlResourceMoveDefinition, CancellationToken) |
Renames a database.
|
| RenameAsync(SqlResourceMoveDefinition, CancellationToken) |
Renames a database.
|
| Resume(WaitUntil, CancellationToken) |
Resumes a database.
|
| ResumeAsync(WaitUntil, CancellationToken) |
Resumes a database.
|
| RevalidateDatabaseEncryptionProtector(WaitUntil, EncryptionProtectorName, CancellationToken) |
Revalidates an existing encryption protector for a particular database.
|
| RevalidateDatabaseEncryptionProtectorAsync(WaitUntil, EncryptionProtectorName, CancellationToken) |
Revalidates an existing encryption protector for a particular database.
|
| RevertDatabaseEncryptionProtector(WaitUntil, EncryptionProtectorName, CancellationToken) |
Reverts an existing encryption protector for a particular database.
|
| RevertDatabaseEncryptionProtectorAsync(WaitUntil, EncryptionProtectorName, CancellationToken) |
Reverts an existing encryption protector for a particular database.
|
| SetTags(IDictionary<String,String>, CancellationToken) |
Replace the tags on the resource with the given set. |
| SetTagsAsync(IDictionary<String,String>, CancellationToken) |
Replace the tags on the resource with the given set. |
| TryGetApiVersion(ResourceType, String) |
Gets the api version override if it has been set for the current client options. (Inherited from ArmResource) |
| Update(WaitUntil, SqlDatabasePatch, CancellationToken) |
Updates an existing database.
|
| UpdateAsync(WaitUntil, SqlDatabasePatch, CancellationToken) |
Updates an existing database.
|
| UpdateRecommendedSensitivityLabel(RecommendedSensitivityLabelUpdateList, CancellationToken) |
Update recommended sensitivity labels states of a given database using an operations batch.
|
| UpdateRecommendedSensitivityLabelAsync(RecommendedSensitivityLabelUpdateList, CancellationToken) |
Update recommended sensitivity labels states of a given database using an operations batch.
|
| UpdateSensitivityLabel(SensitivityLabelUpdateList, CancellationToken) |
Update sensitivity labels of a given database using an operations batch.
|
| UpdateSensitivityLabelAsync(SensitivityLabelUpdateList, CancellationToken) |
Update sensitivity labels of a given database using an operations batch.
|
| UpgradeDataWarehouse(WaitUntil, CancellationToken) |
Upgrades a data warehouse.
|
| UpgradeDataWarehouseAsync(WaitUntil, CancellationToken) |
Upgrades a data warehouse.
|
Explicit Interface Implementations
| Name | Description |
|---|---|
| IJsonModel<SqlDatabaseData>.Create(Utf8JsonReader, ModelReaderWriterOptions) |
Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model. |
| IJsonModel<SqlDatabaseData>.Write(Utf8JsonWriter, ModelReaderWriterOptions) |
Writes the model to the provided Utf8JsonWriter. |
| IPersistableModel<SqlDatabaseData>.Create(BinaryData, ModelReaderWriterOptions) |
Converts the provided BinaryData into a model. |
| IPersistableModel<SqlDatabaseData>.GetFormatFromOptions(ModelReaderWriterOptions) |
Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service. |
| IPersistableModel<SqlDatabaseData>.Write(ModelReaderWriterOptions) |
Writes the model into a BinaryData. |