8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Azure : SQL Server Databases on Azure
Microsoft Azure allows you to create SQL Server databases using a Database as a Service (DBaaS) model, so you don't have to worry about managing virtual machines or patching operating systems. This article gives an overview of how to create and connect to SQL Server databases on Azure.
Related articles.
- SQL Server Databases on Microsoft Azure
- Azure : Installation of an Oracle Database on Azure
- Oracle Databases in the Cloud
Create a New SQL Server Database
Log on to the Azure portal and click the "SQL databases" link on the left toolbar. Click the "+ Add" button.
Enter the database name and click the "Server" link.
Click the "Create a new server" link.
Enter the server name, credentials and the data center location, then click the "OK" button.
Select the pricing tier that offers the correct combination of size, performance and price for you, then click the "Select" button.
If you are happy with the setup information, click the "Create" button.
Wait while the creation takes place.
Once the creation is complete, click on the server name on the resulting screen.
Click the "Firewall" in the right-hand settings pane.
Add any required firewall rules. I clicked the "Add client IP" button, to allow my client PC to access the database, then clicked the "Save" button.
Connect From Management Studio
Open the SQL Server Management Studio on your desktop and open a new connection. Use the fully qualified server name and the credentials you specified during the database creation. Click the "Connect" button.
The database will appear in the SQL Server Management Studio tree.
If you create a new database (right-click on "Databases" and select "New Database"), it is created on Azure and visible in the Management Studio once the creation is complete.
Looking back at the "SQL databases" section of Azure shows the new database has been created.
Notice the pricing tier has been set to "Standard: S0". It makes sense to create new databases through Azure, on an existing server or new server, so you don't use an incorrect pricing tier by accident.
For more information see:
- SQL Server Databases on Microsoft Azure
- Microsoft Azure
- Azure : Installation of an Oracle Database on Azure
- Oracle Databases in the Cloud
- Azure : SQL Database documentation
Hope this helps. Regards Tim...