Migrate to SQL Paas

yasser Mohamed AbdelMoneim 291 Reputation points
2020-06-23T08:35:03.09+00:00

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

Azure Database Migration service
{count} votes

3 answers

Sort by: Most helpful
  1. Malleswara Reddy, G 1,631 Reputation points
    2020-06-23T09:21:39.487+00:00

    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


  2. Leon Laude 85,716 Reputation points
    2020-06-23T09:22:56.687+00:00

    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


  3. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2020-06-24T15:56:11.923+00:00

    @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

    0 comments No comments