Post reply

SQL DB to Oracle

  • April 23, 2007 at 5:20 am

    #173095

    I need to convert my current project which has a backend as SQL Server 2000 to Oracle 9i or 10g with all the data, constraint, stored procedure, functions and triggers. How can this be achieved at the best.


    Arindam Basu
    Software Engineer
    Hewlett Packard India Pvt Ltd.
    Bangalore-17

  • April 23, 2007 at 8:21 am

    #701934

    Tables and data Oracle should have an improt tool for that. However code for procedures, functions and triggers may require you to translate to Oracle or find a tool that can do this. I don't remember any names but there was at least 1 tool that could do that (for the most part) and there are a number of companies that will contract to do the job for you.

  • April 24, 2007 at 5:34 pm

    #702283

    I don't think you need to pay anybody to migrate one RDBMS to the other, Microsoft provided a very long documentation for moving Oracle to SQL Server run a search for it and use the tool in the link below.  Hope this helps.

    http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html

     

    Kind regards,
    Gift Peddie

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

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