问题描述
我想将数据从Microsoft SQL Server 2005中的一个数据库迁移到另一个数据库。我需要先验证检索到的那些行，然后再将它们插入目标数据库的表中。哪种方法适合这种情况？
I want to migrate data from one database to another database in Microsoft SQL Server 2005. I need to verify those rows retrieved before I insert them to the destination database's tables. Which approach is reasonable for this kind of things?
我试图在我的VB.NET程序中使用两个数据集。合理吗？你能建议我吗？
I am trying to use two datasets in my VB.NET program. Is it reasonable? Can you suggest me?
谢谢，
RedsDevils
RedsDevils
推荐答案
这取决于您要讨论的数据量，但是我倾向于将.Net数据集传递给迁移任务，因为这意味着提取所有数据进入记忆。如果必须通过.Net客户端程序执行此操作，则至少应使用DataReader。但是更好的是通过。
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.
这篇关于SQL Server：数据迁移的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！