data migration

Dear All,
I'm having to manage data migration from a proprietary db system to an in-house designed sql server db.
Is there anyone out there who dealt with this and used software or services of companies specialising in this?
All ideas are welcome, thanks in advance!I would export the data as csv or bunch of insert statements and push them into the new db via bulk insert. thats the most db system independent way, I know and it only needs a dozen lines of code.|||The challenge is mapping data elements and logic between the two systems. And you will need to do custom coding for that. Probably a LOT of custom coding.
My advice would be to load the legacy data into staging table in your new database, and then draft sql procedures or scripts to transform it to your new schema. This way the process is repeatable if logical errors occur.
And my advice would be to get a competent DBA to help you with this and expect it to take a couple weeks to get it right.|||I've done something similar to this before.

Basically, what was needed then was to migrate all data from a proprietory db to MSSQL. Luckily, we were able to connect to that database through ODBC. We added that to MSSQL and from there wrote scripts to do the migration.

I agree with blindman, you may need a lot of coding to do this. We spent few weeks to do it cause almost everything (table structures, fields, etc) is different.

It's not difficult but you may need time to do it.