Re: migrating to oracle

From: dan wright <dw420@nospammepleezairmail.net> > >I just wanted some input from people who have worked primarily in >Informix, but also at least dabbled w/ Oracle. > >I'm not worried about technicalites of importing Informix data into an >Orcale databsae...I'm more interested in anything of signifigance in >working w/ Oracle. From my preliminary impressions w/ NetG training CDs >(which are a waste of money IMnsHO) and reading an O'Reilly PL/SQL book >- at about 1/10 the cost of NetG's crappy CDs, it is probably 10 times >more informative. > >Anyway, SQL is SQL isn't it? I imagine DBA work will be more different >than basic app development, but app development will be different >enough.... SQL is not SQL. DBA work is massively different, and we had exceptional fun once porting a Delphi app from one version of Oracle to another. It turned out to be quicker for us to port it to Informix!! One big change is that you *need* a full-time, skilled DBA. Informix is good enough and simple enough that it can muddle along nicely in a development environment, Oracle isn't nearly as forgiving. There are also differences between SQLs and Oracle's PL/SQL is very different from SPL. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.