Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001

    Unanswered: Convert MSSQL to Oracle

    What is the fastest and more simple way to convert MS SQL database (tables, procedures, functions, views) in Oracle DB?



  2. #2
    Join Date
    Feb 2003
    Assuming we're talking a Std MySQL database :-

    No simple way really - well none that I know, after all you're talking chalk from cheese here.

    If you do a MySQL dump you should get all the create table and insert statements you need.
    BUT you would need to check the datatypes for the CREATE TABLE stuff and amend MySQL datatypes to Oracle Datatypes.

    The INSERT commands should be OK though.

    As for functions you'll need to recode these.

    Procedures and Views .... I thought we were talking MySQL ???

    If you are talking MySQL & the InnoDB add-on then I dunno...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts