How to add a database and create a table in Windows Azure SQL databases

June 7, 2012 Windows http://www.aliyun.com/zixun/aggregation/13357.html ">azure releases a preview of the new management interface, and many friends don't know how to add a new interface Windows Azure SQL database (old name SQL Azure), here's a simple demonstration of how do we add a database and build a table if we have a SQL Server?

The first step is to select the left menu SQL Databases on the Windows Azure Management Portal and then click "+" below to prepare a new database.

There are currently two versions of Windows Azure SQL database, with Web Edition and Business edition,web Edition single databases up to 5 gbytes, while Business Edition The maximum capacity of a single database can be up to gbytes, in the image below we must give the database name, the selected Windows Azure SQL database version, the ordering method for storing the data (collation), and select the Server name that has been established. As shown below, press the Tick button to create an empty database named Demo.

Then click the left menu, select just set up the Demo database, you can see the current database capacity usage, server name, and display connection to the database connection string (Connection Strings), and so on screen, we can press the lower right Manage URL, Prepare to enter the database management screen.