如何处理从一个Sqlserver数据库到另一个Sqlserver数据库的大量插入和更新 [英] How Do I Handle Large Amount Of Insertion And Updation From One Sqlserver Database To Another

问题描述

大家好



我创建了一个应用程序，将一个数据库的完整数据传输到另一个数据库，它几乎按我想要的方式工作但是有一些问题即将到来，我无法解决它。

问题是

当应用程序传输具有大量数据的表的数据时（大约10万条记录） ）到另一个表它挂起并显示超时问题并挂断，GUI变为白色空白屏幕显示无响应消息。这两个问题都有解决办法吗。



提前完成待办事项

Hi Everyone

I had created an application to transfer complete data of one database to another database and it almost working the way i want but there are some problems in which i m facing and i m not getting how to resolve it.
The problems is
When the application transfer data of a table having a large amount of data(1 lakh records approx) to another table it hangs up and displays timeout problem and hangs up and the GUI become white blank screen displaying not responding message. Is there any solution to both these problem.

Thanxs in advance

推荐答案

你好，



您是否尝试过使用SqlBulkcopy课程？



以下链接可能对您有帮助..

SQL批量复制方法插入大量的数据到sql数据库 [ ^ ]



使用SqlBulkCopy传输数据 [ ^ ]

Hello,

Have you tried using SqlBulkcopy class?

Following links might help you..
SQL Bulk copy method to insert large amount of data to the sql database[^]

Transferring Data Using SqlBulkCopy[^]

这篇关于如何处理从一个Sqlserver数据库到另一个Sqlserver数据库的大量插入和更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！