4 Replies Latest reply: Jun 7, 2013 3:04 AM by Mkirtley-Oracle RSS

    Migration from SQL SERVER to ORACLE 10G

    sherkhan
      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
          >
          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
            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-Oracle
              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
                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