Cloud DB for MSSQL (VPC) overview

Prev Next

Available in VPC

You can easily build and automatically manage MSSQL databases with Cloud DB for MSSQL. It is a fully managed cloud database service that operates stably through NAVER's optimization settings, and it automatically recovers in case of failure occurrence. Cloud DB for MSSQL provides APIs for database management features in RESTful form.

Common Cloud DB for MSSQL settings

The following describes commonly used request and response formats in Cloud DB for MSSQL APIs.

Request

The following describes the common request format.

API URL

The request API URL is as follows:

https://ncloud.apigw.ntruss.com/vmssql/v2

Request headers

The following describes the request headers.

Field Required Description
x-ncp-apigw-timestamp Required This is the number of milliseconds that have elapsed since January 1, 1970 00:00:00 UTC.
  • Request is considered invalid if the timestamp differs from the current time by more than 5 minutes.
    		•
    x-ncp-iam-access-key Required Access key issued on NAVER Cloud Platform
  • Issue and check access key: See Create authentication key.
  • Issue and check access key for sub account: See Create sub account.
    		•
    x-ncp-apigw-signature-v2 Required Base64-encoded signature that encrypts the request information with a secret key that maps to the access key issued on NAVER Cloud Platform, using the HMAC encryption algorithm (HmacSHA256)
  • Issue and check secret key: See Create authentication key.
  • Create signature: See Create signature.
    		•

    Response

    The following describes the common response format.

    Response status codes

    Cloud DB for MSSQL APIs use NAVER Cloud Platform's common response status codes. For response status codes common to NAVER Cloud Platform, see Ncloud API response status codes.

    Cloud DB for MSSQL API

    The following describes the APIs provided by the Cloud DB for MSSQL API service.

    API Description
    createCloudMssqlInstance Create Cloud DB for MSSQL instances.
    createCloudMssqlSlaveInstance Add Cloud DB for MSSQL slave server instance.
    deleteCloudMssqlInstance Delete Cloud DB for MSSQL instances.
    deleteCloudMssqlServerInstance Delete Cloud DB for MSSQL server instances.
    exportBackupToObjectStorage Cloud DB for MSSQL backup Object Storage export
    exportDbServerLogsToObjectStorage Cloud DB for MSSQL server log Object Storage export
    getCloudMssqlBackupDetailList Get the list of Cloud DB for MSSQL backup details.
    getCloudMssqlBackupList Get the list of Cloud DB for MSSQL backups.
    getCloudMssqlBucketList Get the Object Storage bucket list.
    getCloudMssqlCharacterSetList Get the Cloud DB for MSSQL character set list.
    getCloudMssqlConfigGroupList Get the Cloud DB for MSSQL config group list.
    getCloudMssqlFolderList Get the Object Storage folder list.
    getCloudMssqlImageProductList Get Cloud DB for MSSQL product code list.
    getCloudMssqlInstanceDetail Get Cloud DB for MSSQL instance details.
    getCloudMssqlInstanceList Get the Cloud DB for MSSQL instance list.
    getCloudMssqlLogBackupFileList Get the Cloud DB for MSSQL log backup file list.
    getCloudMssqlLogFileList Get the log file list.
    getCloudMssqlProductList Get the list of Cloud DB for MSSQL server specifications available.
    getCloudMssqlTargetSubnetList Get the list of subnets available.
    getCloudMssqlTargetVpcList Get the list of VPCs available.
    rebootCloudMssqlServerInstance Restart Cloud DB for MSSQL server instances.

    Cloud DB for MSSQL related resources

    NAVER Cloud Platform provides a variety of related resources to help users better understand Cloud DB for MSSQL APIs.