Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating to and from Azure? Expand / Collapse
Author
Message
Posted Friday, August 15, 2014 11:36 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 558, Visits: 1,651
I know that with SQL Server, databases are easily migrated from lower versions to higher versions, but migration from a higher versions to lower versions is difficult & complex. You cannot simply restore a backup from SQL 2012 to SQL 2008.

But what are the restrictions on moving database between SQL Server and Azure? Can databases from SQL 2014 be migrates to Azure? Can a Azure Database be migrated to SQL 2012 or 2008?
Post #1603801
Posted Saturday, August 16, 2014 11:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 14,205, Visits: 28,534
Databases exist in two places in Azure, in Azure Virtual Machines and in Microsoft Azure SQL Database (MASD). The VMs act exactly like physical boxes or VMs local to your environment. You can backup and restore databases, whatever. Anything goes, same as dealing with your local instances. The databases in MASD are completely different. You can't run a standard restore. So, any movement of an entire database is done through scripting. You can export structures as a DACPAC and then run them in MASD. Data can be moved through SSIS and other choices. But the simple attach/detach or backup/restore processes are gone.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1604117
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse