• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

SQL Server to Oracle dba

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    SQL Server to Oracle dba

    I'm thinking of reskilling in this direction over the summer if I can't find another contract.

    Was wondering if anyone else had done this and what obstacles I might face.

    #2
    Oracle gave me lots of sleepless nights

    but then I am no expert

    Comment


      #3
      Originally posted by original PM View Post
      Oracle gave me lots of sleepless nights
      I thought that was going to stay our little secret.

      Comment


        #4
        I did that a couple of years ago, but as a developer, not a DBA. Except I did my OCA cert via the DBA route, because it was (a) cheaper and (b) didn't require any Forms.

        Ignore everything you know about SQL server. Of course many of the concepts are the same, but the implementations are quite different, especially physically.
        Doing the OCA (probably the full OCP if you're a career DBA) is probably a good way to learn the ropes. You can download 10g XE for free, and it runs OK on one of today's medium-spec PCs.

        Comment


          #5
          One thing to consider, most Oracle databases run on Unix/Linux, so you may have to get up to speed with the Operating System too.

          Comment


            #6
            As a SQL Server boy Oracle makes me twitch a dribble a little....

            Comment


              #7
              Originally posted by dandcg View Post
              As a SQL Server boy Oracle makes me twitch a dribble a little....
              I'm not cetain its the route I wan tto take either. Was just considering a few options as part of my continuous improvement plan. Might go out the BI route instead and look at Business Objects or SSRS.

              Spoke to one of the unix guys here and he told me the thought of working with Oracle everyday would be depressing.

              Comment


                #8
                Yes thats a good idea, if you are pure SQL Server at the monent(Developer/DBA), then to branch out into the entire MS BI stack is probably the best bet. Look into SSIS/SSRS/SSAS. As discussed in the other thread I started there seem to be a lot of that around.

                Dan

                Comment

                Working...
                X