将大量数据从SQL Azure导出到本地存储 [英] Export Large amounts of data from SQL Azure to local storage

问题描述

嗨

我目前有一个约500GB的大型数据库，我需要导出旧数据(约16亿行)，以便可以将实时数据库缩减为当前数据.

I current have a large database ~500GB and i need to export old data ( about 1.6 billion rows) so i can reduce the live database down to the current data.

我们有SQL Server 2017的完整版，我正在尝试将特定表导出到本地数据库.

We have a full version of SQL server 2017 and i am trying to export a specific table to a local database. 

我尝试使用SQL Management Studio中的导出向导，直到出现TCP错误然后失败之后，一切都进行得很好.

I tried using the export wizard from SQL management studio and this was going well until a TCP error occurred and it then failed.

我的问题是我不想从头开始-那么下载数据的最佳方法是什么.如果这样做会更强大，我不介意分批执行.

My problem is i do not want to start from the beginning again - so what is the best way to download the data. I don't mind doing it in batches if that would be more robust.

谢谢

john

推荐答案

请检查，

https://sqlbackupandftp.com/blog/how-to-backup-azure-sql-database-to-local-machine

https://sqlbackupandftp.com/blog/how-to-backup-azure-sql-database-to-local-machine

致谢

PT

这篇关于将大量数据从SQL Azure导出到本地存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！