The Azure Cloud Platform Learning Path (ii)--sql Database

1. What is SQL Database?

A managed relational database, a database-as-a-service, IaaS.

2. What are the characteristics?

(1) Provide scalable data storage services for SaaS applications.

(2) Easy to operate a large number of databases. Several ways to manipulate databases are described later.

(3) Higher performance and better stability. High performance scalability based on Azure platform, multi-region disaster recovery backup.

(4) Close to 0 maintenance, no need to maintain other hardware equipment.

(5) Support familiar features, tools and platforms.

(6) Security and auditing functions.

3, the use of enterprises are:

4. Create a database.

(1) Enter https://manage.windowsazure.com/, login account.

(2) The left navigation bar selects SQL database, and the right side displays a list of all SQL databases that have been created. As shown in. The right side can also be displayed as a list of all servers, all of the deleted databases, through a label switch.

(3) Click the New button in the lower left corner, select Data Services-SQL database, and then quick Create and custom create.

(4) If you choose to create quickly, the box that pops up appears as shown in the left. Subscriptions cannot be modified at this time. Enter the name of the database, select the server that your database is running on, and you can create a new server and set the server's location, login name, and password. The location of the server from an efficiency standpoint, it should be as close as possible to your application. If you choose Custom creation, the information that pops up is shown below, and the information you set is a bit more. In addition to setting server locations, logins, and passwords, users are allowed to select performance levels, collations, and so on. Finally click Create SQL database to create a success.

5. Add a table for the database.

(1) Click on the admin button below, may prompt you IP in outside the firewall rules, just click Yes.

(2) Enter a new page, ask you to enter a user name and password, click Login.

(3) Click "Design" in the bottom left corner and click "New Table"

(4) Design the table structure, click the Save button.

(5) The table design function here is limited, you can design the data table through the offline Microsoft SQL Server Management Studio, then export the SQL statement of the table structure, and then "new query" to execute the SQL statement again. SQL Server methods for exporting table structures see: http://www.kangry.net/blog/?type=article&article_id=94

6. Viewing data through SQL Server Management Studio

(1) Open SQL Server Management Studio, click on the file-"Connection object, enter the server name, user name, and password." The service name can be seen in the lower right corner of the https://manage.windowsazure.com/Web site's dashboard page. Then click the Connect button. If you are prompted for IP denial of service, in the lower right corner of the dashboard page of the https://manage.windowsazure.com/website, click Manage allowed IP address to add the current IP.

(2) In this way, you can operate the Azure database as if you were working on a local database. Note that you cannot modify the table structure (except through SQL statements) through SQL Server Management Studio.

7. Use Microsoft Visual Studio to view and modify the database.

(1) Click on the left side of the server explorer-"to the data connection right-click" Add Connection

(2) Data source Select Microsoft SQL Server, click the Continue button.

(3) Enter the server name, user name, user password, select the database, click OK

(4) In this way, you can also view Azure database data with vs. VS can modify the table structure.

8, the database and database server restore, export, delete, copy.

Resources:

[1] http://azure.microsoft.com/zh-cn/services/sql-database/

[2] https://manage.windowsazure.com/

Reprint Please specify: Kangrui tribe? The Azure Cloud Platform Learning Path (ii)--sql Database

The Azure Cloud Platform Learning Path (ii)--sql Database