@datafire/azure_arm_sql
Client library for SqlManagementClient
Installation and Usage
npm install --save datafire @datafire/azure_arm_sql
let datafire = require('datafire');
let azure_arm_sql = require('@datafire/azure_arm_sql').create({
access_token: "",
refresh_token: "",
client_id: "",
client_secret: "",
redirect_uri: "",
});
azure_arm_sql.Databases_ListAdvisors({}).then(data => {
console.log(data);
})
Description
The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases, servers, and other entities.
Actions
Databases_ListAdvisors
Returns a list of database advisors.
azure_arm_sql.Databases_ListAdvisors({
"resourceGroupName": "",
"serverName": "",
"databaseName": "",
"subscriptionId": "",
"api-version": ""
}, context)
Parameters
- resourceGroupName (string) required - The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- serverName (string) required - The name of the server.
- databaseName (string) required - The name of the database.
- subscriptionId (string) required - The subscription ID that identifies an Azure subscription.
- api-version (string) required - The API version to use for the request.
Databases_GetAdvisor
Returns details of a Database Advisor.
azure_arm_sql.Databases_GetAdvisor({
"resourceGroupName": "",
"serverName": "",
"databaseName": "",
"advisorName": "",
"subscriptionId": "",
"api-version": ""
}, context)
Parameters
- resourceGroupName (string) required - The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- serverName (string) required - The name of the server.
- databaseName (string) required - The name of the database.
- advisorName (string) required - The name of the Database Advisor.
- subscriptionId (string) required - The subscription ID that identifies an Azure subscription.
- api-version (string) required - The API version to use for the request.
Databases_CreateOrUpdateAdvisor
Creates or updates a database advisor.
azure_arm_sql.Databases_CreateOrUpdateAdvisor({
"resourceGroupName": "",
"serverName": "",
"databaseName": "",
"advisorName": "",
"parameters": {},
"subscriptionId": "",
"api-version": ""
}, context)
Parameters
- resourceGroupName (string) required - The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- serverName (string) required - The name of the server.
- databaseName (string) required - The name of the database.
- advisorName (string) required - The name of the Database Advisor.
- parameters (object) required - Database Advisor.
- subscriptionId (string) required - The subscription ID that identifies an Azure subscription.
- api-version (string) required - The API version to use for the request.