Data migration from 2005 to 2008, table structure not same?

  • I need to migrate 10 yrs data from sql2005 table to sql2008 table where both tables have different columns. What is good approach here/ any tool? Suggestion?

    Thanks

  • SSIS, tsql, linked servers could help get the job done.

    You would probably want to batch the migration. It wouldn't be hard to do it via a sql agent job and run a regular schedule to migrate the top n records.

    The hard part would be that you would need to do is map out the source to the destination columns.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • You've pretty much outlined what SSIS was built for. But, there's no automatic way to do it. You'll have to build the processes by hand.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply