Showing posts with label Azure SQL Database. Show all posts
Showing posts with label Azure SQL Database. Show all posts

Monday, 14 August 2017

Migrating on-premise SQL Database to Windows Azure SQL Database

Migrating on-premise SQL Database to Windows Azure SQL Database


Migrating SQL database(s) from one server to another is one of the common tasks for SQL DBAs. There are several ways to migrate a SQL database(s). I have already covered how to migrate SQL DB on premise here. Today we will see how do we migrate an on-premise SQL Database to Azure SQL Database. Please follow the below step by step procedure to migrate your on-premise SQL Database to Azure-

1.       You need to login to the Source Server first. This is the Server where your Database, which needs to be migrated to Azure, resides. Login with your account and go to the Source database-> Click on Tasks-> Deploy Database to Windows Azure SQL Database.
Migrate your database to Windows azure SQL Database


2.       Upon clicking on Deploy Database to Windows Azure SQL Database you will be presented with the Deploy Database screen which will be an Introductory screen to provide you some information regarding the Wizard. Click Next

Migrating on-premise SQL Database to Windows Azure SQL Database


3.       Next screen will be Deployment Setting Screen where you need to provide the details for the target Server. Under the Specify Target Connection pane you will see a tab to enter Server connection. Click on the connect button which is situated at the right side of the server connection box. A new Connect to Server window will be popped up and there you should furnish the details of the target Server name and Authentication details. After entering the details click on connect.
Migrate your SQL Database to Windows Azure SQL Database, specify target server name
4.       Upon Clicking next, you will be presented with the below window where you can see the connected server name. you need to furnish some details like the new database name and other seeing details like Edition of windows Azure SQL Database, Maximum database size in GB and Service Objective. Here in our example I have selected “Standard” as the edition of Windows Azure SQL database and 250 GB is what I have mentioned as the Max size of the database and S2 as the Service Objective.

Migrate your SQL Database on Azure

Also, you need to specify a backpac file path in the Deployment Settings window. Once you are done with all these things, click next.

5.       Upon clicking next, a summary page will be shown which will have all the details about Source Server and database, target server and database and environment details.
Step by Step document for Migrating SQL Database to Azure


6.       Validate if all the above details are correct and proceed to click finish. Upon finishing the wizard you will see Operation complete message on the screen once all the operations such as Exporting database, Validating database, processing objects, importing database are complete.

Migrate SQL databases to Windows Azure


7.       To verify whether your newly migrated database has been migrated successfully or not you can go to Portal and check it. Login to portal.azure.com with your credentials and see if the newly created database has been created under SQL Databases Pane. In our example, I logged into Azure portal and verified that the database with the name “test” has been created successfully under the SQL Databases pane.
Migrating on-premise SQL Database to Windows Azure SQL Database

Hence We have seen that Migrating an on-premise SQL server database to Windows Azure SQL Database is very easy and straight forward.

Monday, 24 July 2017

Creating Azure SQL Database from Azure Portal

Creating a new Azure SQL Database from Azure Portal

Azure SQL Database is a database-as-a-service which is highly performance-driven, secure and trustworthy. With Azure SQL Database, you can now create websites or applications without requiring to manage the infrastructure. This enables you to concentrate more on data and application stuff and back-end is managed by Microsoft. Today we will learn how to create Azure SQL Database using Azure Portal.


Please follow below steps-

  1. You need to login to Azure Portal-> portal.azure.com. Please sign up on it if you don’t have an account already.
  2. Once you login to the portal, you need to go to the left pane of the main page and click-> SQL Databases. You will be presented with a window like below-

Create Azure SQL Database using Azure Portal













3) Click Add to add the new Azure SQL Database and you will see the below screen-


configuration settings for Azure SQL Database


4) Fill in all the mandatory details like Database name, Subscription, Resource group, Select source, Server etc. You can use an existing resource group or create a dedicated resource group to be used for the new Azure SQL Database. In Select Source box, you can choose to install a blank database. You also have an option to create a sample database or create a database from a pre-existing backup of any other database.


5) You need to configure Server Setting once you are done with the above specified details. To do that Click on Configure required settings under Server tab. Once you click, you will be presented with another new tab to select an existing server or create a new Server. The screen will look like the one which is copied below-


Configuration and server settings for Azure SQL Database using Azure Portal



6) If we already have a Server we can choose that by selecting that server. In case we want a new Server to be installed altogether for this Azure SQL Database then we will click on the -> Create a new server link and supplying the mandatory information like Server Name, Serveradmin Login, Password and Location. Here in the example I have taken sqltest as the Server Name, Rahul as the Server admin login (please give a strong password for this admin login as you will be later logging in to the SQL Server using this login only). We have selected West Europe as the location. Allow Azure services to access server will be enabled by default and we will leave it as it is.
7) Next, we will have to select the pricing tier for our Azure SQL Database. We can choose among basic, standard, premium and premium rs tiers as per the requirements. Then verify the details of DTU and pricing from the same page and once everything is verified don’t forget to apply the changes.
selecting pricing tiers for Azure SQL Database from Azure Portal











8) Finally, you should select the desired Collation and click on Create.
So, this will create your Azure SQL Database which you can connect from database engine and manage your data. Azure Portal seems very user friendly and direct.