Home » RDBMS Server » Server Administration » import sql database to Oracle database (win 32)
import sql database to Oracle database [message #292602] Wed, 09 January 2008 05:57 Go to next message
janakaecom
Messages: 3
Registered: January 2008
Junior Member

I am new to oracle , so please tell me how to import sql database to Oracle database. I have a one database in sql server 2000 , i need to transfer that it to Oracle database ,how to do that

please help me : janakawap@gmail.com

Report message to a moderator

Re: import sql database to Oracle database [message #292608 is a reply to message #292602] Wed, 09 January 2008 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You have to unload your sql database in a csv format and then load it in Oracle using SQL*Loader.

Regards
Michel

Report message to a moderator

Re: import sql database to Oracle database [message #292622 is a reply to message #292602] Wed, 09 January 2008 07:30 Go to previous messageGo to next message
javon
Messages: 7
Registered: December 2007
Junior Member
Hi.

Oracle SQL Devloper is the tool for you. It has built in migration features for SQL Server.
http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html#mig

Check section 11 - "Migrate from Third Party Databases"

Report message to a moderator

Re: import sql database to Oracle database [message #292629 is a reply to message #292622] Wed, 09 January 2008 07:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Try Database Transformation Service (SQL to Oracle) in SQL

Babu

Report message to a moderator

Re: import sql database to Oracle database [message #292700 is a reply to message #292629] Wed, 09 January 2008 12:23 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, you might check what heterogeneous services offer (it is an Oracle server component that provides the generic technology for accessing non-Oracle systems from the Oracle server).

Report message to a moderator

Previous Topic: Roles
Next Topic: Database consolidation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 05:04:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.