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
Post a Comment