wish to add azure Sql

Question

wish to add azure Sql

scrystal 1

my organization uses azure cloud for file backup. we now wish to add azure Sql for existing databases. what are the steps?

Anurag Sharma 17,631 Reputation points

2022-02-15T12:05:57.3+00:00

Hi @scrystal , welcome to Microsoft Q&A forum. Just wanted to check if you need any further details on this. If answer helped, you can mark it 'Accept Answer'.
scrystal 1 Reputation point

2022-02-15T14:15:53.437+00:00
this was not adequate for my needs.
I have a very small database, less than 2GB.
it is currently used on site in a .Net client server application.
our thought is to move this small ms sql server database to your cloud.
Our requirement is very simple, just move the database and get a new connection string
to use in our client server application.
so before we can make a decision I need the following:

what azure option do you think I should I sign up for and what will it cost?

I suppose I can simply restore the .bak files up to your cloud, I just need to know the tools to use and where to find the tools and how to use them to communicate with my azure, which will have only this one database in it.
The sooner I get specific answers, the sooner we can implement.

3 answers

Your answer

Anurag Sharma 17,631 Reputation points

2022-02-15T12:05:57.3+00:00

Hi @scrystal , welcome to Microsoft Q&A forum. Just wanted to check if you need any further details on this. If answer helped, you can mark it 'Accept Answer'.
scrystal 1 Reputation point

2022-02-15T14:15:53.437+00:00

this was not adequate for my needs.
I have a very small database, less than 2GB.
it is currently used on site in a .Net client server application.
our thought is to move this small ms sql server database to your cloud.
Our requirement is very simple, just move the database and get a new connection string
to use in our client server application.
so before we can make a decision I need the following:

what azure option do you think I should I sign up for and what will it cost?

I suppose I can simply restore the .bak files up to your cloud, I just need to know the tools to use and where to find the tools and how to use them to communicate with my azure, which will have only this one database in it.
The sooner I get specific answers, the sooner we can implement.

Answer 1

Anurag Sharma 17,631

Hi @scrystal , thanks for responding back with more details. Please find the responses below for all your queries:

1) what azure option do you think I should I sign up for and what will it cost?
If this limited time usage you can create free account for Azure SQL Database for 12 months with 250 GB S0 instance with 10 database transaction units.

However as mentioned this service is free for 12 months, so before it expires you can switch on to the pay-as-you-go model. The minimum price per month would be $5 for basic tier and the DTU is limited to 5 only and storage space.

Below is the pricing calculator which would help you in calculating the price based on your requirement of usage and storage:

https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

2) I suppose I can simply restore the .bak files up to your cloud, I just need to know the tools to use and where to find the tools and how to use them to communicate with my azure, which will have only this one database in it.
Azure SQL Database does not currently support restoring the database using the .bak file. But there are multiple ways to migrate the on-premise SQL Database to cloud. Below are few:

A) Using DMS: Tutorial: Migrate SQL Server to Azure SQL Database using DMS: This is suggested way as it does assessment of database before migration and we get to know the issues beforehand if any.
B) Importing a BACPAC file for a SQL database using SSMS: This is a 2 step process, first is to export the existing database in bacpac and then import it to Azure SQL Database.

All these migration techniques are simple and straight forward and if there is any queries we can discuss and resolve them.

For connecting to Azure SQL Database we can choose SQL Server Management Studio or Azure Data Catalog.

Please let us know if this helps you or else we can continue the discussion accordingly. If answer helps, you can mark it 'Accept Answer' as this could help others having similar queries.

scrystal 1 Reputation point

2022-02-15T15:54:02.44+00:00

Anurag,
thank you for your very thorough answer - it was much better.
one question, you said "if this limited time usage"
Is a client-server application considered limited time usage?
I suppose it is similar to a web application that uses session?
but I dont think it is simply Request/Response.
The point is, I think the users stay connected to the database while they are on the client-server application.
Anurag Sharma 17,631 Reputation points

2022-02-15T17:49:04.633+00:00

Hi @scrystal , thanks for reverting back.

By limited time usage I mean to say that we can create the database in cloud by using free subscription up to 12 months for free of cost. Once that period is finished, our application will not be able to access the database anymore. So to access the database again we will need to upgrade our subscription to pay-as-you-go and will be charged as per the billing of the Azure SQL database that we configured based on storage and DTU.

Please let me know if this helps.
scrystal 1 Reputation point

2022-02-15T17:57:22.84+00:00

perfect!
how do I get started with the free program?
Anurag Sharma 17,631 Reputation points

2022-02-15T18:03:46.427+00:00

You can sign in here using your outlook account, or you can create a new outlook account and use it:

Build in the cloud with an Azure free account

Please let me know if you face any issues. If answer helps, you can mark it 'accept answer'.
scrystal 1 Reputation point

2022-02-15T23:29:00.717+00:00

Thank you Anurag for all your help.
I dont think I will be able to use my client server application in the cloud just by changing the connection string to point to the database in the cloud. I dont think anyone knows how to do this.
Anurag Sharma 17,631 Reputation points

2022-02-16T12:33:55.413+00:00

We can get the connection string after creating the Azure SQL Database and checking the connection strings setting as shown in below screenshot:

----------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.
scrystal 1 Reputation point

2022-02-16T18:06:13.593+00:00
Anurag, this is perfect. it is just what I was looking for.
now, before I sign on it looks like I have to make a couple of choices.

I choose
Azure SQL Managed Instance (rather than just Azure SQL Server)

(from "Get started guide for Azure developers")
First, you must decide on how to host your application in Azure
only 4 choices
Azure App Service
Azure Functions
Virtual Machines
Azure Service Fabric

i would like to choose Azure App Service but that is supposed to be only for web applications and mine is thick Client server. So do I need the Virtual Machines option which will be a lot of work? I want the simplest and easiest way to do this.
thanks again for all your help.

Answer 2

Alberto Morillo 34,671 MVP Volunteer Moderator

My suggestion, start by creating an empty database on Azure SQL, then use Azure Data Migration Assistant to perform an assessment of existent on-premises databases targetting the Azure SQL database.

Here you will find how to create an assessment.

Answer 3

scrystal 1

Anurag,
thank you for your very thorough answer - it was much better.
one question, you said "if this limited time usage"
Is a client-server application considered limited time usage?
I suppose it is similar to a web application that uses session?
but I dont think it is simply Request/Response.
The point is, I think the users stay connected to the database while they are on the client-server application.

Share via

wish to add azure Sql

3 answers

Your answer