DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ms Sql

  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Ms Sql

    Question: I have an app based on an MSSQL DB, can I migrate this DB to ORACLE9, including data, tables and stored procs?

    As you certainly might have guessed I am no DB wizz, weorking with Flash, the app is a Remoting application, now I know CF MX can talk to an ORACLE DB, now I just need to know if I can painlessly get that ORACLE DB up and running...

    anyone? Do not need the hows, just wether it is possible.

    Muchos gracias

    V

  2. #2
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Welcome, new member!

    It must be possible.

    Maybe to shortest route is to use a tool that can acces both databases. (i used something like SmartModeler, which could create data-schemas for a multiple of databases. It could do reverse enginering aswell). Use that tool to read the MS SQL schema. Then let the tool create a Oracle script that builds the tablespaces, schemas, tables, indexes, etc, etc. If you don't have the tool, than you maybe have to manually create the objects in Oracle.

    The data.
    Let MS SQL create a Comma Separated Value-file with all the data. You can load that into Oracle with SQLLoader.

    Good luck!
    Last edited by efrijters; 12-11-2003 at 11:04 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Oracle offers the Migration Workbench tool to convert SQL Server databases to Oracle. I've never needed to use it so I cannot tell you how effective or easy to use it is. More information here:

    http://otn.oracle.com/tech/migration...nch/index.html

Posting Permissions

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


Click Here to Expand Forum to Full Width