If the SQL Server database is not that big, you can use Azure Data Migration Assistant to migrate a SQL Server database to Azure SQL Database as explained on this tutorial. The same tool allows you to perform an Assessment first. You can download the latest version from here.
Migrate SQL Server on a VM to Azure SQL Databases
juani
26
Reputation points
Hi everyone, I hope you are very well!
I need to migrate a SQL Server database that we have in a virtual machine to a running SQL Database in a SQL Server and I don't know how to do it. Some help please?
Accepted answer
1 additional answer
Sort by: Most helpful
-
Bjoern Peters 8,781 Reputation points
2022-11-23T13:03:19.59+00:00 Hi @juani
As Alberto already said... that is one of the methods...
I have another for you... using Azure Data Studio and the Data Migration Extension (which I love)
Here you can find the tutorial and documentation for it
https://learn.microsoft.com/en-us/azure/dms/migration-using-azure-data-studio