Migrate to SQL Paas

Question

Hello

I have SQL 2016 always on and it is hosting the below

-One instance for Database
-One instance for SQL reporting services
-4 Databases

what is the best option to migrate all these database to Azure SQL paas

Answer 1

Hi,

You can try out with Managed instance.

Have a quick look on different optoins available
https://www.youtube.com/watch?v=uNvk42lSI7c

Migrating SQL Server -
https://www.youtube.com/watch?v=_x_2nfptCd4&t=2s

Answer 2

Hi,

You can use Azure Database Migration Service to migrate the databases from a SQL Server instance to Azure SQL Database, you'll find more information here:
https://datamigration.microsoft.com/

Here's also some tutorial guides for migrating SQL Servers to Azure SQL PaaS:

Tutorial: Migrate SQL Server to Azure SQL Database offline using DMS
https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql?toc=/azure/azure-sql/toc.json

Tutorial: Migrate SQL Server to an Azure SQL Managed Instance offline using DMS
https://learn.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance?toc=/azure/azure-sql/toc.json

Best regards,
Leon

Answer 3

@yasser Mohamed AbdelMoneim

Your question gives 2 things. First you have 4 databases on the same instance, and you use reporting services. You need to decide on which type of SQL Server you need. Here are some options:

1) SQL Server IaaS approach – If don’t want to change anything in how you use SQL Server, this is the best option. You will have full control over your Data and can use reporting service as needed
2) Azure SQL Single DB/ Elastic DB PaaS approach– If all of your DB’s have same usage, Azure SQL Single DB makes sense where each Database will have its own resources and if the usage is varied and different at different times, You can create a elastic pool. You may have to use different method or keep SSRS on-prem for reporting.
3) Azure SQL managed instance – This is closer to capabilities of On Prem Sql server and also provides you full range of PaaS capabilities but the SSRS also will not work here directly but have to use Cloud BI solutions.

So every approach has its advantages and disadvantages depending on work you want to do. Check what is needed most for your Data and what capabilities you can’t work without. Here is the complete list of comparison between two PaaS approaches and DB migration methods.

Hope this helps.

Thanks
Navtej S