Re: Migration to Oracle

meysam.khayatan_at_gmail.com wrote:
> Hi
> i want to migrate my sqlServer 200 DB to Oracle 9i or oracle 10g
> i download Oracle Sql Developer but i can't use it anyway
> can anyone tell me solution to do this job??
> thanks alot
> Best Regards

Not to be too harsh but the biggest single problem I see in those moving from the MS world to the Oracle world is an inability to read.

To have a chance of being successful with Oracle you must read the docs. Start with the concept docs at http://tahiti.oracle.com, continue with any book written by Tom Kyte, preferably all of them, and then work through demos of which there are many on the web such as those in Morgan's Library at www.psoug.org.

And please don't consider going to 9i ... it is in desupport mode. If you are moving to Oracle you should be focusing on 11gR1. And if you are moving to Oracle you should be focusing on SQL*Plus, which is where learning takes place, rather than a dumbed-down GUI.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org