SQL Server：数据迁移的最佳方法是什么？ [英] SQL Server: What is the best way to Data Migration?

问题描述

我想将数据从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。但是更好的是通过 Sql Server Integration Services 。

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：数据迁移的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！