SQL Server Performance Forum – Threads Archive

Migration to Oracle – From Spanish Forum

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.

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

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…)

Thanks guys.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>