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

k.rajenderen@xxxxxxxxx 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.

HTH,
Brian

--
===================================================================

Brian Peasland
dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: How to determine database market share?
    ... with your meaningful contributions to to .oracle lists over the time ... It was not "Something about measuring database market penetration by ... > On the DB2 side, many of the people who are DB2 DBA's have been doing ... > On the SQL Server side, there are 2 questions involved, how many real ...
    (comp.databases.oracle.server)
  • Re: Equivalent of Oracles export/import in sql server
    ... I would not say a blanket statement like "Oracle ... DBAs should learn SQL Server" or "SQL Server DBAs should learn DB2". ... I would highly recommend learning Relational Database Theory. ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: Proposal: 6NF
    ... SQL SERVER, ORACLE and DB2 have the same heritage then... ... grey areas then they are probably not mathematics. ...
    (comp.databases.theory)