azure-mgmt-sql

Microsoft Azure SQL Management Client Library for node

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
azure-mgmt-sql
1,181130.9.178 years ago9 years agoMinified + gzip package size for azure-mgmt-sql in KB

Readme

Microsoft Azure SDK for Node.js - SQL Database Management
This project provides a Node.js package that makes it easy to manage Microsoft Azure SQL Database. Right now it supports:
  • Node.js version: 0.6.15 or higher
  • API version: 2012-03-01

Features

  • Manage server
  • Manage database
  • Manage firewall rule
  • Manage service objective
  • Manage database copy
  • Manage database operation
  • Manage DAC (dedicated administrator connection)

How to Install

```bash npm install azure-mgmt-sql ```

How to Use

Authentication

This library support management certificate authentication. To authenticate the library for the REST API calls, you need to
  • Have a management certificate set up in your Microsoft Azure subscription. You can do this by
Either uploading a certificate in the Microsoft Azure management portal. Or use the Microsoft Azure Xplat-CLI.
  • Obtain the .pem file of your certificate. If you used Microsoft Azure Xplat-CLI to set it up. You can run `azure account cert export` to get the .pem file.
  • Open the .pem file in a text editor to get the cert value and key value.

Create the SqlManagementClient

```javascript var fs = require('fs'),
sqlManagement = require('azure-mgmt-sql');
var sqlManagementClient = sqlManagement.createSqlManagementClient(sqlManagement.createCertificateCloudCredentials({ subscriptionId: '', pem: fs.readFileSync('') })); ```

Manage Database

```javascript var sqlDatabaseName = "database01"; // Create a SQL database server. sqlManagementClient.servers.create({ administratorUserName: "", administratorPassword: "", location: "West US" }, function (err, result) { if (err) {
console.error(err);
} else {
sqlServerName = result.serverName;
console.info(result);
// Create a SQL database.
sqlManagementClient.databases.create(result.serverName, {
name: sqlDatabaseName,
edition: common.Constants.SqlAzureConstants.WEB_EDITION,
collationName: common.Constants.SqlAzureConstants.DEFAULT_COLLATION_NAME,
maximumDatabaseSizeInGB: common.Constants.SqlAzureConstants.WEB_1GB
}, function (err, result) {
if (err) {
console.error(err);
} else {
console.info(result);
}
});
} }); ```

Related projects