Migrate Database From IaaS to Paas

Daniel Nascimento 281 Reputation points
2022-01-11T12:01:12.04+00:00

Hello,

Hope you are doing well.

I've a question and i hope you guys can help me.

At this moment we want to migrate SQL Server and MySQL that exist as VM's to PaaS services such as SQL Managed Instance and MySQL database.

Azure have any tool that simplifies this, since our infrastructure is already in Azure. If not, do you have any tips to do that?

Thanks in advance.

Azure SQL Database
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
927 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 47,441 Reputation points
    2022-01-11T12:15:31.89+00:00

    Regarding MS SQL Server migration, here you can use the free tool DMA = Data Migration Assistant, see Overview of Data Migration Assistant

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Daniel Nascimento 281 Reputation points
    2022-01-11T16:57:29.18+00:00

    @Olaf Helper thank you for your answer. So basically I could use the same tools I used to migrate to azure?

    0 comments No comments

  2. GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator
    2022-01-13T00:37:08.077+00:00

    Hello @Daniel Nascimento Thanks for the question and using MS Q&A platform

    Thanks, @Olaf Helper for your contribution and for providing the documentation.

    In Addition to OlafHelper-2800 yes you can use the DMA tool

    164532-image.png

    You can also use SSMS:
    Do Export operations From SSMS using by Creating the .bacpac file using SSMS Export and Importing the .bacpac file using SSMS Import and from the Portal : You can import a SQL Server database into Azure SQL Database or SQL Managed Instance using a BACPAC file

    Regards
    Geetha


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.