想要为超过65,00000条记录执行批量复制的建议 [英] want suggestion for performing bulk copy for more than 65,00000 records

问题描述

大家好，

先生，请告诉我最简单的方法，将Ms Access Table批量复制到sql server Table.我也想显示进度条以进行更新.我想将其开发为Windows应用程序.

Hello to all,

Please sir tell me the simplest way to do bulk copy from Ms Access Table to sql server Table. and i also want to show a Progressbar for the updation. I want to develop this as windows application.

推荐答案

首先，获取所有记录的计数.然后，小批量复制它们；比方说一次10,000然后，您将获得当前进度和目标进度的计数……您可以从中创建进度条.

First, get a count of all the records. Then, copy them in small batches; say, 10,000 at a time. You will then have a count of your current progress and your target count... you can create a progress bar from that.

这篇关于想要为超过65,00000条记录执行批量复制的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！