Shulou(Shulou.com)06/01 Report--

As an important storage of core data, database is often faced with the need of data migration, such as business migration from local to cloud, data center failure need to be switched to disaster recovery center, data synchronization under hybrid cloud or multi-cloud deployment, database performance bottleneck caused by sudden increase in traffic needs to be split …...

This article will take you step by step to implement RDS For SQL Server on the cloud on a single database.

Create a RDS For SQL Server instance

Open JD.com Cloud console: https://console.jdcloud.com/, click Database Database and Cache-Cloud Database RDS in the left navigation, select North China-Beijing region, and click the create button.

Select the billing type (here, because of the test, select by configuration). Click Buy now after selecting the configuration in the figure below.

After confirming the order information, click activate immediately, and wait a few minutes to complete the creation of the database instance.

Create an account

Create a test library and grant the account read and write permissions

Second, create local test data

1. Create a Win Server CVM

According to JD.com Cloud's existing CVM specifications, the minimum memory requirement is 8GB and 4GB. During the installation of SQL Server, insufficient memory will be indicated, so the minimum requirement: 4-core 8GB

Create a Win Server CVM as follows

After the creation is completed, it is shown below:

2. Install sql Server20162.1 JDK download and install

Remotely connect to the Win Server CVM. As part of Microsoft's integration with big data, a new Polybase feature has been added to SQL Server 2016. This feature requires Oracle JRE7 or higher to be installed, so we need to install jdk in advance and download the address:

Public network: https://pocenv-hcc.s3.cn-north-1.jdcloud-oss.com / jdk-8u211-windows-x64.exe

Intranet (North China-Beijing): http://pocenv-hcc.s3-internal.cn-north-1.jdcloud-oss.com / jdk-8u211-windows-x64.exe

Download address for other versions: https://www.oracle.com/technetwork/ java/javase/downloads/jdk8-downloads-2133151.html2.2 Sql Server2016 Enterprise Edition download and installation

Download the Sql Server2016 installation image. For convenience, I have uploaded the version image used for operation to Jingdong Cloud COS, download address:

Public network: https://pocenv-hcc.s3.cn-north-1.jdcloud-oss.com / cn_sql_server_2016_enterprise_x64_dvd_8699450.iso

Intranet (North China-Beijing): http://pocenv-hcc.s3-internal.cn-north-1.jdcloud-oss.com / cn_sql_server_2016_enterprise_x64_dvd_8699450.iso

Download address for other versions: https://msdn.itellyou.cn/, as shown below:

After the download is completed, the installation starts. First, we right-click the image to load it. After the load is complete, double-click setup to start the installation * *

Select [install a new SQL Server standalone or add features to an existing installation]

If you have a key, you can enter a key; if not, you can use the [Evaluation] version.

After accepting the license terms, the next step

Global rule validation

Update recommendation

Product update and installation

Installation rules

Function selection

Because it is a new installation, select all features.

Next, keep the default next step until the following interface appears, and we specify the password for oa and configure it in mixed mode. Add the current user to the administrator

Analysis Services configuration

Select the table mode and also add the current user as the administrator.

Distributed Replay controller

Add permissions for the current user

Distributed Replay client

Agree to install Microsoft R Open

Then, by default, the installation starts after the next step until the installation is complete.

Note: the installation process will be stuck for a period of time, just wait patiently.

2.3 install SSMS through [install SQL Server Management tools]

After clicking, automatically open the download page of SQL Server Management Studio (SSMS), and click the link shown in the figure to download.

I have uploaded the SSMS installation package to Jingdong Cloud COS in advance:

Intranet (North China-Beijing): http://pocenv-hcc.s3-internal.cn-north-1.jdcloud-oss.com / SSMS-Setup-CHS.exe

Public network: https://pocenv-hcc.s3.cn-north-1.jdcloud-oss.com / SSMS-Setup-CHS.exe

When the download is complete, double-click to start the installation

Installation completed

3. Simulate local test data

Open Microsoft SQL Server Management Studio 17, connect to Sql Server, and Ctrl+N calls up the command line to do the following (each step of the operation command is selected separately and then press F5 to execute):

3.1 create a library

1CREATE database testhanchaochao

3.2 create a test table 1USE testhanchaochao in the test library

2CREATE TABLE StuInfo

3 (

4 StuID INT-- student number

5 StuName NVARCHAR (20)-- name of the student

6 Sex NVARCHAR (20)-Student gender

7)

8BEGIN

9 DECLARE @ DataCount INT = 100;-- Total data

10 DECLARE @ CurrentCount INT = 1;-- current number

11 DECLARE @ Sex NVARCHAR (20);-- Student gender

twelve

13 WHILE @ CurrentCount

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.