Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Jorge Bendahan
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, Jorge Bendahan.
Here are detailed solution:
http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm#
 
Roldson Isria
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic