Global Azure SQL Server Database Export and Import configuration introduction

Global Azure SQL Server Database Export and Import configuration introduction

Our previous article introduced the backup and restore configuration of global Azure SQL Server, and today we'll talk about the export and import features of global Azure SQL Server, actually speaking about exporting and importing, We all think, in fact, is to export the data into a format, and then in another environment to import, which is a bit like the function of backup and restore, but also can be understood as the functionality of the migration, but according to the official site of the field definition is exported and imported, in the global Azure SQL Server The principle of database export is to export the entire schema of the databases to the storage account (the exported format file is Xx.bacpac), and then the download can use the data in the storage account to import into another running SQL environment, see below:

Before exporting, we still connect through SQL Server Manage Studio and confirm that the data is complete

Note: The exported data will be placed under the storage account

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image002" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE89bQPwJ7AABq8S863M0086.jpg" height= "319"/>

We first create a storage account Sqldbback

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image004" src= "http://s3.51cto.com/wyfs02/M00/79/05/wKiom1aE87jTgL6UAACBkqGdkOE140.jpg" height= "454"/>

Then create a container with a blob named Sqlexport under the storage account.

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image006" src= "http://s3.51cto.com/wyfs02/M01/79/04/wKioL1aE89jDPkiKAACXsK-37V4230.jpg" height= "462"/>

Then we export the database

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image008" src= "Http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE89iii2qfAABvT8xofVo125.jpg" height= "304"/>

When exporting, we define the path that needs to be imported into the storage account and container

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image010" src= "http://s3.51cto.com/wyfs02/M01/79/05/wKiom1aE87ujOn0GAACDkuGHMAQ719.jpg" height= "424"/>

Then you need to enter database administrator information to verify

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image012" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE89rimuzvAABuX0JGdn4913.jpg" height= "421"/>

After confirming the information, start exporting the data

650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image014" src= "http://s3.51cto.com/wyfs02/M02/79/05/wKiom1aE873xpfRCAAB1AV-rP9c062.jpg" height= "407"/>

Hint that you have submitted the information for the exported database

650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image016" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE892zj8mkAABu9YbDOlc965.jpg" height= "196"/>

As prompted, we review the history of export and import

650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image018" src= "http://s3.51cto.com/wyfs02/M00/79/05/wKiom1aE87_yyZ_5AAClkkF_1FM767.jpg" height= "514"/>

Click to view the history of import and export

650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image020" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE897QzkzzAAB9wY30C4Y345.jpg" height= "331"/>

We look at an export history, and the status is already complete.

650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image022" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE8-LTNGNDAABUDQA-3vA357.jpg" height= "451"/>

Then we go into the storage account under the container

650) this.width=650; "title=" clip_image024 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image024" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE8-Sz4GU5AAB8wvK8_TA530.jpg" height= "445"/>

To see that there is an exported data message

650) this.width=650; "title=" clip_image026 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image026" src= "http://s3.51cto.com/wyfs02/M02/79/05/wKiom1aE88ajhuAmAACYk5PdYP0105.jpg" height= "437"/>

We will download the exported data information to the local

650) this.width=650; "title=" clip_image028 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image028" src= "http://s3.51cto.com/wyfs02/M00/79/05/wKiom1aE88fQwoFtAABrT-cUgRM300.jpg" height= "449"/>

Start downloading the exported data information

650) this.width=650; "title=" clip_image030 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image030" src= "http://s3.51cto.com/wyfs02/M01/79/05/wKiom1aE88jygT5LAABguZ9Gk4I049.jpg" height= "292"/>

Download complete

650) this.width=650; "title=" clip_image032 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image032" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE8-exGBzCAAA8tsyoDQo573.jpg" height= "299"/>

Then we find a local SQL Server to import its operations;

Right-click the database---Import the data-tier application

650) this.width=650; "title=" clip_image034 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image034" src= "http://s3.51cto.com/wyfs02/M02/79/05/wKiom1aE88nz7GzUAACap0lMf2Y857.jpg" height= "325"/>

Based on the thought of the next step

650) this.width=650; "title=" clip_image036 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image036" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE8-nS1a3CAAC0kWabofM581.jpg" height= "423"/>

There are two ways, one is from the local and the other is imported from the Azure storage account

650) this.width=650; "title=" clip_image038 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image038" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE8-rxs5OIAADCjLZA2XY338.jpg" height= "413"/>

Then we recommend that you modify the database name

650) this.width=650; "title=" clip_image040 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image040" src= "http://s3.51cto.com/wyfs02/M01/79/04/wKioL1aE8_bwQ17JAADUDpWzWlY545.jpg" height= "429"/>

Preparing to import

650) this.width=650; "title=" clip_image042 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image042" src= "http://s3.51cto.com/wyfs02/M02/79/05/wKiom1aE89rTBhUuAAC7gktpB5Y291.jpg" height= "428"/>

Import prompt Error

650) this.width=650; "title=" clip_image044 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image044" src= "http://s3.51cto.com/wyfs02/M01/79/05/wKiom1aE89uBelVbAACjySwwgiY553.jpg" height= "357"/>

Based on the error, we fix the problem, it is possible that the SQL Server version on Azure is relatively high;

And my local version is SQL Server2014, so we need to make a SP1 patch for the local SQL Server 2014

Start installing SQL Server SP1 patch

650) this.width=650; "title=" clip_image046 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image046" src= "http://s3.51cto.com/wyfs02/M00/79/05/wKiom1aE89zwLFJbAACzU4VQFn8290.jpg" height= "384"/>

Upgrade all features by default

650) this.width=650; "title=" clip_image048 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image048" src= "http://s3.51cto.com/wyfs02/M02/79/05/wKiom1aE893AzLejAACdAsoU1yY701.jpg" height= "389"/>

Preparing to upgrade your environment

650) this.width=650; "title=" clip_image050 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image050" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE8_3CP6shAACTYW5eIEg501.jpg" height= "381"/>

Upgrade conditions Meet

650) this.width=650; "title=" clip_image052 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image052" src= "http://s3.51cto.com/wyfs02/M01/79/04/wKioL1aE8_6zxkVvAACMC2aYWTo953.jpg" height= "382"/>

Start updating SQL Server2014 version

650) this.width=650; "title=" clip_image054 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image054" src= "http://s3.51cto.com/wyfs02/M01/79/05/wKiom1aE8-DwIbl5AAB80JF-OtY418.jpg" height= "385"/>

Upgrade complete

650) this.width=650; "title=" clip_image056 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image056" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE8__yq1r0AACZcpbdo8A945.jpg" height= "379"/>

After we hit the patch, we started to import

650) this.width=650; "title=" clip_image058 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image058" src= "http://s3.51cto.com/wyfs02/M02/79/04/wKioL1aE9AGTTap7AACh2VbQ9gI017.jpg" height= "297"/>

Start importing data-tier apps

650) this.width=650; "title=" clip_image060 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image060" src= "http://s3.51cto.com/wyfs02/M00/79/04/wKioL1aE9AKRA29_AACrTGt4BqY422.jpg" height= "395"/>

Data import Complete

650) this.width=650; "title=" clip_image062 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image062" src= "http://s3.51cto.com/wyfs02/M00/79/05/wKiom1aE8-Sj8y3OAADGxkDYF5Q086.jpg" height= "385"/>

After importing, we view the imported database information by name

650) this.width=650; "title=" clip_image064 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image064 "src=" http://s3.51cto.com/wyfs02/M01/79/05/wKiom1aE8-by8TQIAACmorGwhSU894.jpg "height=" 374 "/>

This article from "Gao Wenrong" blog, declined reprint!

Global Azure SQL Server Database Export and Import configuration introduction