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?
Add a comment
|
1 Answer
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:
- Data-tier Application DAC Package
- Data-tier Application BACPAC Packag
- Generate Scripts Wizard
- bcp
- SQL Database Migration Wizard
- SQL Server Integration Services
- SQL Server Import and Export Wizard
- SQL Server Migration Assistant
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.
1 Comment
rollsch
The above guide has been updated and only explains how to migrate from SQL Server to Azure, not the reverse.