# azure-mgmt-sql

> Microsoft Azure SQL Management Client Library for node

Latest version **0.9.17** (published 2015-03-25) · 0 weekly downloads

## Install

```sh
npm install azure-mgmt-sql
pnpm add azure-mgmt-sql
yarn add azure-mgmt-sql
bun add azure-mgmt-sql
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.9.17 |
| Published | 2015-03-25 |
| First published | 2014-01-14 |
| Weekly downloads | 0 |
| TypeScript types | none |
| Module format | CommonJS |
| Node | >= 0.6.15 |
| Dependencies | 2 |
| Known vulnerabilities | 0 (+2 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 1174 |
| Author | Microsoft Corporation |
| Maintainers | windowsazure |
| Keywords | node, azure |

## Links

- npm: https://www.npmjs.com/package/azure-mgmt-sql
- Repository: git@github.com:Azure/azure-sdk-for-node
- Homepage: http://github.com/Azure/azure-sdk-for-node
- Issues: http://github.com/Azure/azure-sdk-for-node/issues
- npm.io page: https://npm.io/package/azure-mgmt-sql

## Dependencies (2)

- [underscore](https://npm.io/package/underscore.md) 1.4.x
- [azure-common](https://npm.io/package/azure-common.md) 0.9.11

## Alternatives

- [@expo/fingerprint](https://npm.io/package/@expo/fingerprint.md) — 6.2M weekly downloads
- [@azure/monitor-opentelemetry-exporter](https://npm.io/package/@azure/monitor-opentelemetry-exporter.md) — 850.0K weekly downloads
- [@azure/monitor-opentelemetry](https://npm.io/package/@azure/monitor-opentelemetry.md) — 624.0K weekly downloads
- [@posthog/ai](https://npm.io/package/@posthog/ai.md) — 423.3K weekly downloads
- [fakefilter](https://npm.io/package/fakefilter.md) — 63.9K weekly downloads

## Recent versions

- 0.9.17 (latest) — 2015-03-25
- 0.9.16 — 2015-02-09
- 0.9.15 — 2015-01-21
- 0.9.14 — 2014-12-02
- 0.9.13 — 2014-11-08
- 0.9.12 — 2014-10-03
- 0.9.11 — 2014-09-10
- 0.9.10 — 2014-08-12
- 0.9.9 — 2014-07-30
- 0.9.8 — 2014-06-23
- 0.9.7 — 2014-06-20
- 0.9.6 — 2014-06-05
- 0.9.5 — 2014-05-02
- 0.9.4 — 2014-04-30
- 0.9.3 — 2014-04-29
- … 3 more at https://npm.io/package/azure-mgmt-sql/versions

## 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](https://manage.windowsazure.com).
  * Or use the [Microsoft Azure Xplat-CLI](https://github.com/Azure/azure-xplat-cli).
* Obtain the .pem file of your certificate. If you used [Microsoft Azure Xplat-CLI](https://github.com/Azure/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: '<your subscription id>',
  pem: fs.readFileSync('<your pem file>')
}));
```

### Manage Database

```javascript
var sqlDatabaseName = "database01";

// Create a SQL database server.
sqlManagementClient.servers.create({
  administratorUserName: "<your admin user name>",
  administratorPassword: "<your admin password>",
  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

- [Microsoft Azure SDK for Node.js](https://github.com/WindowsAzure/azure-sdk-for-node)

---
_Source: https://npm.io/package/azure-mgmt-sql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._