Windows Azure Create Management database
In the previous article we introduced the features on Windows Azure, which today mainly describes how to create SQL databases and manage databases on Windows Azure. Databases created on Azure can only be managed remotely through SQL Manage studio, while setting the Allow linked IP to be managed remotely while database operations management on Windows Azure can only be managed through SQL statements. Haha, give me the feeling back to school days, teachers teach you to manage the database through SQL statements, this time there is a useful.
We first open the Windows Azure Control Panel, select the SQL Database Features menu, click New
650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image002 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253061eNDN.jpg "height=" 278 "/>
Select Custom Create
650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image004 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253061NJW5.jpg "height=" 277 "/>
Specify the name of the database, database size, version, and other information
650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image006 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253061bgSu.jpg "height=" 290 "/>
Here I set: The database name is: Msdatabase, version is Standard Edition, performance default, size 1GB, database rule default, will be introduced later in the database rule.
650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image008 "src=" http://img1.51cto.com/attachment/201407/25/451336_14062530619clr.jpg "height=" 282 "/>
Database size 1GB
650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image010 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253064cYlr.jpg "height=" 313 "/>
650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image012 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253068uEwa.jpg "height=" 338 "/>
Set the login name and password for the database
650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image014 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253068lEJs.jpg "height=" 275 "/>
Create complete.
650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image016 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253068y3si.jpg "height=" 290 "/>
We look at the link name of the database server:
650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image018 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253068emrq.jpg "height=" 271 "/>
We then tried to manage it through SQL Manage studio, prompting for failure and not allowing remote management
650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image020 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253068uidW.jpg "height=" 312 "/>
From this error view, should be the installation settings on Azure, do not allow the address link, you need to add the address to run the link
650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image022 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253071Nzbs.jpg "height=" 273 "/>
We view the configuration after we open the database settings
650) this.width=650; "title=" clip_image024 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image024 "src=" http://img1.51cto.com/attachment/201407/25/451336_14062530718se0.jpg "height=" 272 "/>
Click
650) this.width=650; "title=" clip_image026 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image026 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253071coqD.jpg "height=" 276 "/>
650) this.width=650; "title=" clip_image028 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image028 "src=" http://img1.51cto.com/attachment/201407/25/451336_14062530713nYl.jpg "height=" 274 "/>
650) this.width=650; "title=" clip_image030 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image030 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253071iv2B.jpg "height=" 273 "/>
After adding, we try to link again
650) this.width=650; "title=" clip_image032 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image032 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253072iE03.jpg "height=" 321 "/>
650) this.width=650; "title=" clip_image034 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image034 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253072P5Ts.jpg "height=" 292 "/>
650) this.width=650; "title=" clip_image036 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image036 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253075gW3h.jpg "height=" 243 "/>
CREATE DATABASE Domino_loggo
650) this.width=650; "title=" clip_image038 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image038 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253075vfq8.jpg "height=" 291 "/>
650) this.width=650; "title=" clip_image040 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image040 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253075uqLt.jpg "height=" 280 "/>
I define the following fields:
650) this.width=650; "title=" clip_image041 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image041 "src=" Http://img1.51cto.com/attachment/201407/25/451336_1406253075lvZr.png "height=" 189 "/>
So use the following command:
Use Databadenameif object_id (' databadename.tablename ', ' U ') are not nulldrop TABLE test.tablename; Gocreate TABLE tableName (ID NCHAR () PRIMARY KEY not Null,servername VARCHAR (), Data Datetime,[time] Time (7), Info Varch AR (+)) GO
Test database name tableName table name
Test Replace Sbweb
So the result of the substitution is as follows:
650) this.width=650; "title=" clip_image043 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image043 "src=" http://img1.51cto.com/attachment/201407/25/451336_140625307878cM.jpg "height=" 314 "/>
650) this.width=650; "title=" clip_image045 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image045 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253078xrEV.jpg "height=" 298 "/>
650) this.width=650; "title=" clip_image047 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image047 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253078FnVL.jpg "height=" 336 "/>
SELECT * FROM Domino_log.dbo.Domino_logs
650) this.width=650; "title=" clip_image049 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image049 "src=" http://img1.51cto.com/attachment/201407/25/451336_1406253079Dyry.jpg "height=" 332 "/>
This article from "Gao Wenrong" blog, declined reprint!