Ingest Data into Azure SQL Database using SSMS

Today, I'm going to show you how to ingest data into

the Azure SQL Database using SQL Server Management Studio. Let's get started. I'm going to come to this Demo Sales Database

so click on that. Then I can for now click on the Query Editor

and I want to see the table in my database. I'm going to go on and login with my credentials and click okay

I'm going to click on this tables and expand. I've got FTransaction table

I can go on and just write a simple select top five star from the FTransaction table

and then I can go on and run the query. This is going to return the top five records from the FTransaction table

We're going to go to the SQL Server Management Studio. In SQL Server, I want to click on the Connect in

the Object Explorer and choose Database Engine. In the Database Engine, I'm going to provide my server name

easily get that information by coming back to the overview in the Microsoft Azure

I'm going to for now click okay to un-save that. Then in the overview

I can see my server name displayed at the top here. So just go ahead and copy

Of course, to successfully connect to the SQL Server Management Studio, it is important to set the firewall

So click on the set server firewall, and then you want to scroll down

and then it is essential you click on add your client IP for address

Then once you do that, go ahead and save at the bottom

Then you should be able to login properly into the SQL Server Management Studio

So I'm going to come back here, and then I've got my server name, and of course, for the authentication

I specified SQL Server authentication, and then for my login, I've got my name and my password

and click on Connect. I'm successfully connected to the server. So I'm going to click on the Databases plus sign to expand

and then I'm going to see the demo sales database. So I'm going to expand

and of course, I'm going to come to the table, and then we should be able to see the F transaction table

we saw earlier in the Azure SQL database. Okay, so we have the database owner F transaction

So we want to go on and ingest this dimension tables. I've got lots of them in the CSV file

and then I'm going to go back to the SSMS, and then I'm going to right click on the demo sales database

and select task, and then we'll point to import data. For the data source

I'm going to click on this dropdown, and I'm going to scroll down. I want to access the Microsoft Excel

and then I can go on and browse through the Excel file path

and then we have the Excel version. So the first row has column names

So click on Next, and I want to choose the destination. Now I'm going to click on this dropdown

and I'm going to point to the Microsoft OLE database provider for SQL

Click on that. For the authentication, I'm going to click on this use SQL server authentication

and then for the username, I'm going to type my username, and then I'm going to type my password

and then of course, we have the demo sales database selected automatically

Now I can go on and click on Next, and then we have this copy data

from one or more tables of views. So click on Next, and then we can see all the worksheets

I can select the deep account manager category and so on downwards

and then click on Next. So we can go on and run immediately

in the save and run package. So click on Next, and then we have the complete wizard finished

to perform the following operations or actions. Click on Finish. So we can see that the data is being ingested

into my demo sales database. Okay, so there we go. We can see status, success

and then I can click on Close to close the window. I can right click and refresh the database

Right click and choose Refresh. So we should be able to see all the dimension tables

in the demo sales database. So click on the tables, and there we go

So we can see all the dimension table. I can right click on account manager

and select the top 1000 rows. Okay, so this is working pretty fine

Now I want to go back to the Azure SQL database, and then I want to click on

or go back to the SQL databases in the left panel and choose the demo sales database

And I want to click on the Query Editor. Click on that

And then I want to sign in using my authentication SQL server

And then when I come to the tables, I can see all the dimension tables

And of course I can just query one of them. So let's select style from the account managers table

And then we can go on and run the query. Okay, there we go

So this is basically how we can use the SQL server management studio

to ingest data into the Azure SQL database. I trust that you enjoyed this video

If you do, give it a thumbs up, share with your friends and comment

Thank you for watching. Bye for now