CODEWITHSUNDEEP
sql-serversql-server-2008azureclouddatabase-migration
user1569367
user1569367

Reputation: 93

Migrating from SQL Azure to SQL Server

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?

Upvotes: 6

Views: 2070

Answers (1)

AvkashChauhan
AvkashChauhan

Reputation: 20571

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:

  1. Data-tier Application DAC Package
  2. Data-tier Application BACPAC Packag
  3. Generate Scripts Wizard
  4. bcp
  5. SQL Database Migration Wizard
  6. SQL Server Integration Services
  7. SQL Server Import and Export Wizard
  8. 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.

Upvotes: 4

Related Questions