Results 1 to 8 of 8

Thread: Transition

  1. #1
    Join Date
    Jan 2004
    Posts
    18

    Unanswered: Transition

    I just got a call from a recruiter who knows most of my experience is with Oracle Databases. He has a client that is looking for a Sql Server DBA. He said that they don't mind someone coming from an Oracle background. However, how different are the 2.
    Will this cause me problems later? Is it hard to transition from Oracle to SQL Server?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Admin or programmer/database designer? Admins will have a worse time crossing the great divide, but programmers will have an easier time going from Oracle to MSSQL. Fewer knobs to twist (storage settings per segment are non-existant in MSSQL).

  3. #3
    Join Date
    Jan 2004
    Posts
    18
    Originally posted by MCrowley
    Admin or programmer/database designer? Admins will have a worse time crossing the great divide, but programmers will have an easier time going from Oracle to MSSQL. Fewer knobs to twist (storage settings per segment are non-existant in MSSQL).

    This is for a DBA.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    That's a pretty broad brush...

    What are the requirements?

    And hey, a gig is a gig...you working now?

    Also, having multiple rdbms's on the resume is a good thing...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2004
    Posts
    18
    The requirements are just basic database administration on a database a little less than a gig.

    I basically come in and tell them what they need to have or get.

    I am working now but my contract ends in 2 weeks.

    What do you mean "A gig is a gig?"

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    gig....like a job...

    Sounds like a good oportunity...

    Go get some books now....

    http://www.sqlteam.com/store.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Going to MSSQL Server, I think the bigest leap you will have to make is that there is no auto-archive. Transaction logs must be dumped by a script, schedule, or manually. Or else not "kept" (as in noarchivelog mode).

    Good luck.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Besides that everything else will be a breeze....at least you won't have to deal with SQL+...Enterprise Manager and Query Analyzer will be a pleasure....

    Just stay away from the wizards....which for an Oracle background should be too bad...

    Did you use any 3rd party developer tools while supporting Oracle?

    Did Oracle ever come up with an UNLOAD utility?

    It's been awhile..
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •