How to upgrade from V11 to V12 SQL Azure? -


i using v11 sql azure.

at stage not want upgrade existing sql server contains current qa , production dbs.

logically seems safer create new sql server setup v12, somehow copy/migrate v11 db instances v11 sql server new v12 sql server ie qa dbs start with. aware of: v12 upgrade article

is possible , how?

the easiest way create new v12 server , export databases , import them new server.

there few ways this, either use portal (https://manage.windowsazure.com) , click database , click export button @ top, export database azure storage. import click new, data services, import , select bacpac file storage account , select new v12 server import to.

your other option download ssms (https://msdn.microsoft.com/en-us/library/mt238290.aspx) , login both servers. right click database want export, , go tasks -> export data-tier application. select local storage download database locally. import, right click databases folder on v12 server , go tasks -> import data-tier application.

at point straight forward way go v11 v12 without upgrading server directly.


Comments

Popular posts from this blog

java - Andrioid studio start fail: Fatal error initializing 'null' -

android - Gradle sync Error:Configuration with name 'default' not found -

StringGrid issue in Delphi XE8 firemonkey mobile app -