This week's book giveaways are in the Cloud and AI/ML forums.
We're giving away four copies each of Cloud Native Patterns and Natural Language Processing and have the authors on-line!
See this thread and this one for details.
Win a copy of Cloud Native PatternsE this week in the Cloud forum
or Natural Language Processing in the AI/ML forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

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

 
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.
 
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.
 
Bartender
Posts: 10336
Hibernate Eclipse IDE 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.
 
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
 
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#
 
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!