如何从V11升级到V12 SQL Azure? [英] How to upgrade from V11 to V12 SQL Azure?

问题描述

我正在使用V11 SQL Azure.

I am using V11 SQL Azure.

在此阶段，我不想升级包含现有所有QA和生产数据库的现有SQL服务器.

At this stage I do not want to upgrade my existing SQL server which contains all my current QA and Production DBs.

从逻辑上讲，为V12创建新的SQL Server安装程序似乎更安全，然后以某种方式将V11数据库实例从我的V11 Sql Server复制/迁移到我的新V12 SQL Server，即开始的QA DB.我知道: V12升级文章

Logically it seems safer to create a new SQL Server setup for V12, then somehow copy/migrate the V11 DB instances from my V11 Sql Server to my new V12 SQL Server ie QA DBs to start with. I am aware of: V12 Upgrade article

这可能吗?

推荐答案

最简单的方法是创建一个新的V12服务器，然后导出数据库并将其导入到新服务器中.

The easiest way to do this would be to create a new V12 server and then export the databases and import them into the new server.

有几种方法可以执行此操作，您可以使用门户( https://manage.windowsazure.com )和单击数据库，然后单击顶部的导出按钮，这会将数据库导出到Azure存储.要导入，请依次单击新建"，数据服务"，导入"，然后从您的存储帐户中选择bacpac文件，然后选择要导入到其中的新V12服务器.

There are a few ways to do this, you could either use the portal (https://manage.windowsazure.com) and click the database and click the Export button at the top, this will export the database to Azure Storage. To Import click New, Data Services, Import and select the bacpac file from your storage account and select the new V12 server to import it to.

您的另一个选择是下载SSMS( https://msdn.microsoft.com/en-us/library/mt238290.aspx )并登录到两台服务器.右键单击要导出的数据库，然后转到任务"->导出数据层应用程序".选择本地存储以在本地下载数据库.要导入，请右键单击V12服务器上的Databases文件夹，然后转到Tasks-> Import Data-tier Application.

Your other option is to download SSMS (https://msdn.microsoft.com/en-us/library/mt238290.aspx) and login to both servers. Right click the database you want to export, and go to Tasks -> Export Data-tier Application. The select local storage to download the database locally. To Import, right click the Databases folder on your V12 server and go to Tasks -> Import Data-tier Application.

这是从V11到V12的唯一直接方法，而无需直接升级服务器.

At this point this is the only straight forward way to go from V11 to V12 without upgrading your server directly.

这篇关于如何从V11升级到V12 SQL Azure?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！