传输/转换数据从SQL Server 2008数据库到另一 [英] Transfer/Transform Data From SQL Server 2008 DB to Another

问题描述

我还改写了旧的程序，并设计了一个新的数据库吧。我需要将旧数据转移到新的数据库。新的数据库有一个新的模式，所以我将不得不操纵多，将要传输的数据的。

I have rewritten an old program and designed a new database for it. I need to transfer the old data to the new database. The new database has a new schema, so I will have to manipulate much of the data that is going to be transfered.

我曾经想过写一个控制台应用程序有2 LINQ to SQL的背景下，每个数据库和编码转换逻辑和插件。

I have thought about writing a console app with 2 linq to sql contexts, one for each database and coding the transformation logic and the inserts.

我也想过使用SSIS，但我从来没有使用过。

I have also thought about using SSIS, but I have never used it before.

时的SSIS适合这样的事情？我在哪里可以学习如何做到这一点在SSIS？

Is SSIS suited for this sort of thing? Where can I learn how to do this in SSIS?

推荐答案

它可以和适合于这一点，但如果你还没有使用过它的学习曲线是有点陡峭和安装/配置可能有点钝。

It can and is suited for this but if you haven't used it the learning curve is a little steep and setup / config can be a bit obtuse.

如果你是familar使用LINQ然后我会走这条路努力学习SSIS特别是如果这是一个一次性的事情，时间是一个因素了。

If you are familar with Linq then I would go that route before trying to learn SSIS especially if this is a one time thing and time is a factor.

还有一个在SQL Server中导入和导出向导（使用SSIS），您可以设置直接将文件从一个表到另一个和/或自定义的SQL语句。这应该适用于相当简单的转换。对于需要更先进的逻辑是行不通的转换。

There is also the import and export wizard in SQL Server (uses SSIS) and you can setup straight copies from one table to another and / or custom sql statements. This should work for fairly simple conversions. For transformations that require more advanced logic it won't work.

这篇关于传输/转换数据从SQL Server 2008数据库到另一的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！