我还改写了旧的程序,并设计了一个新的数据库吧。我需要将旧数据转移到新的数据库。新的数据库有一个新的模式,所以我将不得不操纵多,将要传输的数据的。
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.