How to create a SQL Database In Azure

To create a single database in the Azure portal this quickstart starts at the Azure SQL page.

Browse to the Select SQL Deployment option page.

Under SQL databases, leave Resource type set to Single database, and select Create.

On the Basics tab of the Create SQL Database form, under Project details, select the desired Azure Subscription.

For Resource group, select Create new, enter myResourceGroup, and select OK.

For Database name enter mySampleDatabase.

For Server, select Create new, and fill out the New server form with the following values:

Server name: Enter mysqlserver, and add some characters for uniqueness. We can't provide an exact server name to use because server names must be globally unique for all servers in Azure, not just unique within a subscription. So enter something like mysqlserver12345, and the portal lets you know if it is available or not.

Server admin login: Enter azureuser.

Password: Enter a password that meets requirements, and enter it again in the Confirm password field.

Location: Select a location from the dropdown list.

Select OK.

Leave Want to use SQL elastic pool set to No.

Under Compute + storage, select Configure database.

This quickstart uses a serverless database, so select Serverless, and then select Apply.

Select Next: Networking at the bottom of the page.

On the Networking tab, for Connectivity method, select Public endpoint.

For Firewall rules, set Add current client IP address to Yes. Leave Allow Azure services and resources to access this server set to No.

Select Next: Additional settings at the bottom of the page.

On the Additional settings tab, in the Data source section, for Use existing data, select Sample. This creates an AdventureWorksLT sample database so there's some tables and data to query and experiment with, as opposed to an empty blank database.

Select Review + create at the bottom of the page:

On the Review + create page, after reviewing, select Create.

I hope this helps!

Ben Martin

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Praveen Sreeram10y ago
Accepted answer
Hi Delpin,
Please have a look at the following article to create the Azure Logical SQL Server and a SQL Azure database.
http://www.c-sharpcorner.com/article/create-azure-database-and-use-it-via-C-Sharp/
And, what do you mean by import? Are you planning to import a database from on-premise to Azure?
Thanks,
Prawin
Ben Martin5y ago
To create a single database in the Azure portal this quickstart starts at the Azure SQL page.
Browse to the Select SQL Deployment option page.
Under SQL databases, leave Resource type set to Single database, and select Create.

On the Basics tab of the Create SQL Database form, under Project details, select the desired Azure Subscription.
For Resource group, select Create new, enter myResourceGroup, and select OK.
For Database name enter mySampleDatabase.
For Server, select Create new, and fill out the New server form with the following values:
Server name: Enter mysqlserver, and add some characters for uniqueness. We can't provide an exact server name to use because server names must be globally unique for all servers in Azure, not just unique within a subscription. So enter something like mysqlserver12345, and the portal lets you know if it is available or not.
Server admin login: Enter azureuser.
Password: Enter a password that meets requirements, and enter it again in the Confirm password field.
Location: Select a location from the dropdown list.
Select OK.
Leave Want to use SQL elastic pool set to No.
Under Compute + storage, select Configure database.
This quickstart uses a serverless database, so select Serverless, and then select Apply.

Select Next: Networking at the bottom of the page.

On the Networking tab, for Connectivity method, select Public endpoint.
For Firewall rules, set Add current client IP address to Yes. Leave Allow Azure services and resources to access this server set to No.
Select Next: Additional settings at the bottom of the page.

On the Additional settings tab, in the Data source section, for Use existing data, select Sample. This creates an AdventureWorksLT sample database so there's some tables and data to query and experiment with, as opposed to an empty blank database.
Select Review + create at the bottom of the page:
On the Review + create page, after reviewing, select Create.

I hope this helps!
Ben Martin
Vasanth Natarajan10y ago
Hi...
https://azure.microsoft.com/en-in/documentation/articles/sql-database-develop-dotnet-simple/