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

    Post Unanswered: convert Ms SQL 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
    109
    uh you should push it from SQL Server to Oracle using SQL Server DTS-- obvioulsy the best ETL tool in the world.

    why would you possibly move from SQL Server to Oracle again?

    you know that SQL Server is rated as the faster db at www.tpc.org??
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  3. #3
    Join Date
    Mar 2003
    Location
    Kuala Lumpur, Malaysia
    Posts
    3

    Question

    Originally posted by aaron_kempf
    uh you should push it from SQL Server to Oracle using SQL Server DTS-- obvioulsy the best ETL tool in the world.

    why would you possibly move from SQL Server to Oracle again?

    you know that SQL Server is rated as the faster db at www.tpc.org??
    If I'm not wrong, there is a free tool to convert MS SQL to Oracle. Try checking out from Oracle. I personally wouldnt trust a tool from M$ to convert MS SQL to another DB. U think M$ would wanna loose money??

    Anyway, I cant seem to find the tool now. If u can wait, I'll post it as soon as I find it.

  4. #4
    Join Date
    Feb 2003
    Posts
    109

    uh its free with sql server also

    uh its free with sql server also


    www.sqldts.com

    and you can access any DBMS with the tool-- but then again you need to install the Oracle Client software on the server if you want to do anything on a scheduled basis

    im just tired of dealing with bloatware like a application servers and all that other garbage.

    i dont want to install a webserver when i install oracle!!!
    i mean-- why would i EVER install APACHE on windows?
    Access 2002 ADP Rocks my World

    Long live SQL Server and 64bit Windows!!!

  5. #5
    Join Date
    Mar 2003
    Location
    Kuala Lumpur, Malaysia
    Posts
    3

    Question

    Originally posted by aaron_kempf
    uh you should push it from SQL Server to Oracle using SQL Server DTS-- obvioulsy the best ETL tool in the world.

    why would you possibly move from SQL Server to Oracle again?

    you know that SQL Server is rated as the faster db at www.tpc.org??
    If I'm not wrong, there is a free tool to convert MS SQL to Oracle. Try checking out from Oracle. I personally wouldnt trust a tool from M$ to convert MS SQL to another DB. U think M$ would wanna loose money??

    Anyway, I cant seem to find the tool now. If u can wait, I'll post it as soon as I find it.

Posting Permissions

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