Results 1 to 4 of 4

Thread: data migration

  1. #1
    Join Date
    Mar 2005

    Unanswered: 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!

  2. #2
    Join Date
    Aug 2006
    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.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    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.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  4. #4
    Join Date
    Sep 2006
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts