Hi all, I have a database in Ms Sql Server and I was asked to migrate this db to Oracle 10g, I know standard SQL and T-SQL but I have pretty much no experience with Oracle 10g, could you recommend me a book or something to help me with this task. Thanks.
Not a big issue. With a bit of effort, you can migrate from MS.SQL Server to Oracle. Both MS.SQL Server and Oracle are RDBMS, It is very easy to migrate. No need to change the table structure or database structure.
Please generate SQL Script of tables from MS.SQL and check the compatibility with Oracle. Create a batabase and execute those scripts in Oracle (directly or using toad or raptor). Your schema structure will be created. Again generate insert scripts from MS.SQL Server and execute in Oracle.
Your migration will be finished.
(SCJP5.0, IBM Rational Solution Designer, IBM Rational Architect, IBM RUP Designer)
Please generate SQL Script of tables from MS.SQL and check the compatibility with Oracle.
Using SQL Server's DDL generation is unlikely to work, it will be littered with T-SQL keywords and SQL Server-specific DDL options.
To address the original question, the Oracle documentation itself is pretty decent. Outside of that PL/SQL in a Nutshell is a good reference, but if you are up to speed with T-SQL you should feel at home with PL/SQL pretty quickly.
I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool