OraFAQ Forum: Server Administration » SQL Server 2000 db migration to Oracle 9i

Home » RDBMS Server » Server Administration » SQL Server 2000 db migration to Oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Server 2000 db migration to Oracle 9i [message #110965]

Fri, 11 March 2005 09:33

sujayg
Messages: 1
Registered: March 2005
Location: Bangalore

Junior Member

Hi,

Can anyone let me know of a tool which shall migrate the entire SQL Server 2000 database to Oracle 9i along with all the stored procedures . Someone in the net has posted that a tool comes with the Oracle 9i software but I have no idea what it is and how to use it .

Any help would be appreciated .

Thanks ,

Sujay

Report message to a moderator

Re: SQL Server 2000 db migration to Oracle 9i [message #110971 is a reply to message #110965]

Fri, 11 March 2005 10:17

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Google for oracle migration workbench.

Report message to a moderator

Re: SQL Server 2000 db migration to Oracle 9i [message #112520 is a reply to message #110965]

Sat, 26 March 2005 11:57

kumar_dba
Messages: 16
Registered: March 2005
Location: chandigarh

Junior Member

acc to me sqlldr is the tool

Report message to a moderator

Re: SQL Server 2000 db migration to Oracle 9i [message #112527 is a reply to message #112520]

Sat, 26 March 2005 13:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Kumar_dba wrote
>>acc to me sqlldr is the tool

sqlldr??!!
My understanding is sqlldr is a tool to read the data in a text file and load it into an oracle table.
The OP is looking for a tool to migrate SQLserver database to Oracle database.
How can you do this with sqlldr? ( unless like, you spool all the data out of sqlserver into text file and load into oracle using sqlldr). Still it cannot handle stored procedures

Report message to a moderator

Re: SQL Server 2000 db migration to Oracle 9i [message #112542 is a reply to message #110965]

Sat, 26 March 2005 22:54

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Agree with Mahesh..sqlldr may be a tool you can use as part of your solution, and may be a tool used by a migration package you can buy, but it won't cut it by itself.

Also, you can't (well, shouldn't) just do a blanket migration between ANY two databases without doing a lot of testing. Every database handles things differently, particularly in areas such as read consistency (or lack thereof) and locking issues. SQL is not SQL.

Report message to a moderator

Previous Topic:	EXECUTE privilege
Next Topic:	sort_area_size too small

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:00:08 CST 2025