aspose file tools*
The moose likes Oracle/OAS and the fly likes Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)" Watch "Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)" New topic
Author

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

Jorge Bendahan
Ranch Hand

Joined: Apr 11, 2008
Posts: 82
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

Joined: Jun 20, 2009
Posts: 80
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.


VAMSI MOHAN.V
(SCJP5.0, IBM Rational Solution Designer, IBM Rational Architect, IBM RUP Designer)
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


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.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
John Vincent
Greenhorn

Joined: Aug 25, 2009
Posts: 1
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

Joined: Oct 02, 2009
Posts: 49
Hi, Jorge Bendahan.
Here are detailed solution:
http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm#


RAQ Report: Web-based Excel-like Java reporting tool.
Roldson Isria
Greenhorn

Joined: Oct 31, 2009
Posts: 2
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Migrating from Ms Sql Server(T-SQL) to Oracle database 10g(PL-SQL)
 
Similar Threads
What time we will use oracle as a back-end?
printing to server console
9i + 10g integration
Oracle DB Link to SQL Server 2000
Network Adapter