Menu
As we all know there are lots of tools to migrate the database from SQL server to SQL Azure with schema & data..but is there any way to migrate an SQL Azure database to a SQL server with data?
394
In SQL Server Management Studio (SSMS), right-click on the Azure SQL Database that needs to be migrated, then click Tasks, and finally click on Deploy Database to Microsoft Azure SQL Database… In the Deploy Database Wizard, click Next, then click Connect to connect to the target / destination SQL Server Database.
In the Azure portal, search for resource mover. Then, under Services, select Azure Resource Mover. In Overview, click Get started. In Move resources > Source + destination, select the source subscription and region.
Most of the database migration tools are described here in great details and please follow the link at the bottom section name "Migrate between SQL Databases" and here you will see the following tools described with installation guidance along with screenshot to explain how to use them:
As most of above tool runs on your local machine (a few of them are running in cloud as well) so once you have connectivity established between your desktop and SQL Database, you can backup data from one side to other side, means from SQL Database to SQL Server Database or vice versa.
140
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
