这取决于您所讨论的数据量，但我倾向于传递 .Net 数据集来执行迁移任务，因为这意味着将所有数据拉入内存。如果您必须通过.Net 客户端程序执行此操作，请至少使用 DataReader。但更好的是通过 Sql Server 集成服务。
It depends on how much data you're talking about, but I'd tend to pass on .Net datasets for a migration task, as that means pulling all the data into memory. If you must do this via a .Net client program, at least use a DataReader instead. But what's even better is to keep it all in Sql Server via Sql Server Integration Services.
发布评论
评论（1）
这取决于您所讨论的数据量，但我倾向于传递 .Net 数据集来执行迁移任务，因为这意味着将所有数据拉入内存。如果您必须通过.Net 客户端程序执行此操作，请至少使用 DataReader。但更好的是通过 Sql Server 集成服务。
It depends on how much data you're talking about, but I'd tend to pass on .Net datasets for a migration task, as that means pulling all the data into memory. If you must do this via a .Net client program, at least use a DataReader instead. But what's even better is to keep it all in Sql Server via Sql Server Integration Services.