Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    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?


    Thanks

    Franky
    Franky@jepca.com

  2. #2
    Join Date
    Feb 2003
    Posts
    45
    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
  •