Geek Answers Handbook

Transferring / converting data from a SQL Server 2008 database to another

I rewrote the old program and developed a new database for it. I need to transfer old data to a new database. The new database has a new schema, so I will have to manipulate most of the data that will be transferred.

I was thinking of writing a console application with 2 linq to sql contexts, one for each database and encoding the conversion and insertion logic.

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

Is SSIS suitable for this kind of thing? Where can I find out how to do this in SSIS?

0
source share
2 answers

It may be suitable for this, but if you haven’t used it, the learning curve is a little steep and the setup / configuration can be a little dumb.

If you are familiar with Linq, I would go this way before trying to learn SSIS, especially if it is one time and time is a factor.

There is also a Import and Export Wizard in SQL Server (uses SSIS), and you can configure direct copies from one table to another and / or custom SQL statements. This should work for fairly simple conversions. For conversions that require more advanced logic, this will not work.

0
source

I would go with SSIS. This is an ETL tool (this is what you do). In addition, you will learn something new.

Here is some great SSIS content

What are the recommended training materials for SSIS?

+1
source

More articles:


All Articles