This discussion is archived
4 Replies Latest reply: Jun 7, 2013 1:04 AM by mkirtley-Oracle RSS

Migration from SQL SERVER to ORACLE 10G

sherkhan Explorer
Currently Being Moderated
Dear Expert,


I want to migrate from MS SQL server to oracle , I tried to use developer 3.2.20, but not succeeded, can you help me to execute my task successfully.


Thanks,
  • 1. Re: Migration from SQL SERVER to ORACLE 10G
    rp0428 Guru
    Currently Being Moderated
    >
    I tried to use developer 3.2.20, but not succeeded
    >
    And what, exactly, does that mean. Any help you get has to be based on the information that you post and so far you haven't posted any.

    Provide the 4 digit Oracle version, the EXACT steps that you executed to perform the migration and the EXACT result of those steps.
  • 2. Re: Migration from SQL SERVER to ORACLE 10G
    O.Developer Journeyer
    Currently Being Moderated
    hi

    I have done this 3 years before. We have done exact structure and recreate each table as we had different table structrue than legacy.

    You should provide more info on your SQL server db size , is the oracle going to be same or different structure..etc.





    >
    Dear Expert,


    I want to migrate from MS SQL server to oracle , I tried to use developer 3.2.20, but not succeeded, can you help me to execute my task successfully.


    Thanks,
  • 3. Re: Migration from SQL SERVER to ORACLE 10G
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    We're revamping our online information for 3rd party database support.

    Check out the step-by-step, video assisted, content we have for Sybase ASE. It will be an almost exact same process for SQL Server.
    http://www.oracle.com/technetwork/products/migration/sybase-085571.html

    How far along the process do you get before it 'doesn't work?'

    Edited by: Jeff Smith SQLDev PM on Jun 4, 2013 4:31 PM
  • 4. Re: Migration from SQL SERVER to ORACLE 10G
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    You can also get further information about migrations in general here -

    http://www.oracle.com/technetwork/database/migration/index-084442.html

    and SQL*Server migration specifically here -

    http://www.oracle.com/technetwork/products/migration/sqlserver-095136.html

    Regards,
    Mike

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points