I'm working on data migration from SQL Server 2000 to Oracle on Linux (Red Hat Enterprise). My question is should I use SQL*Loader and Oracle Workbench or pass through SQL Server 2005 in order to reach my aim or is there any easier tool to use?
Personally, I've never been comfortable with tools like the Oracle Migration Workbench for my migrations from one RDBMS platform to another. Every time I've used them, I have had to fix the many problems the tool introduced. Plus there is no tool that I know of which does a decent job of migrating T-SQL stored procedures, triggers, etc. to Oracle's PL/SQL. So I have always performed these types of migrations more manually. I do often use SQL Server's Data Transformation Services (DTS) through ODBC to move the data from SQL Server to Oracle. But I use this tool after I have already created my tables and indexes. Then I re-create my views, procedures, triggers and other database objects.
Dig Deeper on Oracle database export, import and migration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.