Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Equivalent of Oracle's export/import in sql server

Re: Equivalent of Oracle's export/import in sql server

From: joel garry <joel-garry_at_home.com>
Date: Mon, 27 Aug 2007 14:05:43 -0700
Message-ID: <1188248743.997123.284180@q5g2000prf.googlegroups.com>


On Aug 27, 7:28 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> k.rajende..._at_gmail.com wrote:
> > Hai,
>
> > I'm new to Oracle DBA . Is it is recommended to study SQL Server along
> > with Oracle.Please don't ignore this mail as it is more vital for me
> > also like to all those like me.just reply me all ur suggestions as i'm
> > waiting for that.Plz reply
>
> > Rajenderenk
>
> Many DBAs end up learning more than one RDBMS because their company uses
> more than one RDBMS. I would not say a blanket statement like "Oracle
> DBAs should learn SQL Server" or "SQL Server DBAs should learn DB2".
> What does your company use? In my case, my employer has implemented lots
> of Oracle, SQL Server, and mySQL. Unfortunately, we even have MS Access
> (although not a true RDBMS) in use which I often get called on to lend a
> hand.
>
> I would highly recommend learning Relational Database Theory. Take time
> to learn the theory behind how database systems work. From there, learn
> how to apply that theory in practice. I went to college and learned
> quite a bit of how databases are supposed to work. When I got a job as
> an Oracle DBA, I spent time learning how Oracle works keeping in mind
> that theory. When I was asked to manage SQL Server, I was able to pick
> up SQL Server quite easily by knowing....here is the theory...here is
> how Oracle does it...oh look...here is how SQL Server does a similar
> implementation. I realize that is a generic statement and there are
> places where things don't easily match up to that statement. But when
> learning a new system, that type of approach has served me well. I've
> never worked with DB2 yet. But I would think that knowing database
> theory would help me pick up DB2. Oracle and SQL Server handle their
> transaction logs quite differently, but theory states that there will be
> transactions logged to some facility. I would be willing to be that DB2
> has some facility to do the same. I would just need to know how DB2
> handles this same concept.
>

I strongly agree with Brian. I first learned about theory, then on other rdbms that didn't use SQL, so when I first ran into Oracle and a couple of other db's around early '83 I blew away the guy in charge of the project with how fast I picked up on them. Same with Sybase and Unify a few years later. But by the early '90's, I saw Oracle as the way to go for business apps. Nowadays db heterogenicity is here to stay, so knowing the theory and how implementations vary from it is as important as ever. You can always figure out the details as you need them, and you also see where the implementations are silly. In the end, you make apps work.

jg

--
@home.com is bogus.
When the US is the offshore site...
http://www.australianit.news.com.au/story/0,,22317807-15306,00.html?from=public_rss
Received on Mon Aug 27 2007 - 16:05:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US