Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)

[Jorge Bendahan]

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.

[Vamsi Mohan]

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.

[Paul Sturrock]

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.

[John Vincent]

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


Download Free : http://www.dbload.com

[Samuel Behrman]

Hi, Jorge Bendahan.
Here are detailed solution:
http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm#

[Roldson Isria]

A tool to convert database are available on google, you can search for convert db, i use it for such database migration process, you too can try this tool.

Find Here : http://www.convert-db.com