Migration database from oracle to sql server 2005

  • Hi friends,

    Management has decided to migrate all oracle 9i database to sql server 2005.

    I don't have experience on migration, Could anyone give me clear doc & planing and step-by-step guide or URL site name.

    Thanks.

  • You need to create the same structure in SQL server .

    You can bcp out the datas from oracle and bcp in the same to SQL. No issues in bcp since the structure is same on both.

    You need to manually create the users i think.

    There are so many tools available for the migration.(i haven't used any)

  • You can also think about SSIS.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • ananda.murugesan (9/15/2009)


    Hi friends,

    Management has decided to migrate all oracle 9i database to sql server 2005.

    I don't have experience on migration, Could anyone give me clear doc & planing and step-by-step guide or URL site name.

    Thanks.

    You can look at the SSMA For Oracle (free Tool)

    http://www.microsoft.com/sqlserver/2005/en/us/Migration-oracle.aspx

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • simply hire me for the job, lol

    Well I have migrated Sybase 15 to SQL Server 2008 successfully using SSMA.

    I suggest managemnet to reconsider it to SQL Server 2008

    [font="Arial"]Yogesh Puri
    Database LEAD/ Database Architect (Sybase, SQL Server, Database Designing, Database Migration, PowerBuilder, ASP, PHP, mySQL, postGreSQL)[/font]
  • I've used SQL Server DTS successfully, so I'm sure the SSIS packages are just as nice. I've also used the SSMA for migrating Access, fairly clean interface also.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.

Viewing 6 posts - 1 through 5 (of 5 total)

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