The moose likes Oracle/OAS and the fly likes Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent" Watch "Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent" New topic
Author

Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent

sumit malik
Greenhorn

Joined: Oct 31, 2001
Posts: 21
Hi
Please tell me how to migrate SQlserver 2000 database to Oracle 8i.
If through Sql loader than how to do it plz. tell me the code.
Is there any tool for such type of
migration also.
Thanks
Sumit
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Sumit,
OMWB is a tool used for this purpose.
Read more...
http://otn.oracle.com/tech/migration/workbench/content.html
Regards
Beksy
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 16624

Hey Beksy, I downloaded the Migration tool and ran the Universal Installer, I then selected the Tool, and it failed to run.
Does it need to be on a Win 2000 at least, or will Win 98 SE work? I have Win 98 SE, and that is where it failed.
Well I think I will just use SQL Loader with ASCII files instead.
Thanks for the link
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Mark,
As far as I know, it should work with Win 98.
see this support matrix
http://technet.oracle.com/support/tech/migration/workbench/htdocs/supp_matrix.htm
Regards
Beksy
 
 
subject: Migration from SQL server2000 to Oracle 8i Enterprise Edition----Urgent
 
Threads others viewed
difference between oracle 8i and sql server 2000?
backup
How do I start using PL/SQL
oracle 8i connectivity
Changing job roles, from team leader to DBA, what to think about ?
developer file tools