一、工具介绍:
1、第三方工具 SqlAzureMW
2、数据迁移助手DMA
下载: microsoft.com/en-us/download/details.aspx?id=53595
3、通过bacpac文件导入
导出:sqlpackage.exe /Action:Export /ssn:.\sqlexpress /sdn: 数据库名 /tf: 备份名字.bacpac
导入:sqlpackage.exe /a:import /tcs:”data source=lzsserver.database.chinacloudapi.cn;user id=”; password=”; /sf:文件名.bacpac /p:databaseedition=premium /p:databaseserviceobjective =p6
![图片[1]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-109.png)
![图片[2]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-108.png)
![图片[3]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-107.png)
二、通过DMA迁移数据库
![图片[4]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-86.png)
![图片[5]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-87.png)
检查报告类型
![图片[6]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-88.png)
选择源端数据库
![图片[7]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-89.png?x-oss-process=image/resize,m_fill,h_531,w_1024)
选择需要迁移的数据库
![图片[8]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-90.png?x-oss-process=image/resize,m_fill,h_549,w_1024)
开始评估
![图片[9]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-91.png?x-oss-process=image/resize,m_fill,h_532,w_1024)
评估结果
![图片[10]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-92.png?x-oss-process=image/resize,m_fill,h_530,w_1024)
配置迁移
![图片[11]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-93.png)
选择迁移架构 或 架构和数据 或 仅迁移数据
![图片[12]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-94.png)
选择源服务器和数据库
![图片[13]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-96.png)
选择目标服务器,SQL验证方式
![图片[14]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-97.png?x-oss-process=image/resize,m_fill,h_540,w_1024)
选择目标数据库
![图片[15]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-98.png)
选择迁移对象(角色、数据库结构、表、数据等)
![图片[16]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-99.png)
![图片[17]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-100.png)
注意:出现黄色感叹号代表该迁移项有风险,可能存在迁移出错或数据丢失
生产脚本(可保持脚本用于在其他数据库导入)
![图片[18]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-101.png?x-oss-process=image/resize,m_fill,h_537,w_1024)
点击Deploy schema发布架构
![图片[19]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-102.png)
架构发布成功
![图片[20]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-103.png?x-oss-process=image/resize,m_fill,h_527,w_1024)
点击开始迁移
![图片[21]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-104.png?x-oss-process=image/resize,m_fill,h_533,w_1024)
迁移成功
![图片[22]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-105.png)
验证PaaS数据库表是否迁移成功
![图片[23]- FBIKIM数据库迁移工具- FBIKIM](https://fbi.kim/wp-content/uploads/2019/11/image-106.png)
© 版权声明
文章版权归作者所有,未经允许请勿转载。
THE END