SQL Server Performance

Migration to Oracle - From Spanish Forum

Discussion in 'Analysis Services/Data Warehousing' started by Luis Martin, Nov 27, 2004.

  1. Luis Martin Moderator

    Hi,

    I need to migrate datawareousing from SQL to ORACLE. What files I have to migrate?

    Thanks,

    Marisa





    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  2. Raulie New Member

    Hola, necesitaria para migrar un datawarehousing de sql server a oracle, saber cuales son los archivos que debo migrar.
    Muchas Gracias
    Marisa

    I don't think moving some files will cover it. If she has stored procedures, functions, triggers in TSQL they will need to be converted PL/SQL language there are tools to help in this process. If she just wants to move the data then I think her best bet is to create the datawarehouse (tables) in Oracle then load the data from SQL Server using an ETL.

    This site provides help on Object differences from SQL Server to Oracle.
    http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx


    Raulie
  3. mmarovic Active Member

    There is an Oracle tool called Oracle Migration Workbench or something like that. It was far from perfect on Oracle 8 (or it was 9), I remember it did his job migrating tables but failed to migrate most of sql code. And for migrating tables - tables were created and populated, but of course they have to be tuned (data types, indexes etc...)
  4. Luis Martin Moderator

    Thanks guys.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page