Post reply

Moving over from Oracle

  • March 21, 2014 at 10:48 am

    #305344

    I have recently retired from my previous job as an Oracle DBA, now I'm working for a small IT firm where I'll be doing some SQL Server work - not heavy-duty DBA work, but database creation and data admin stuff. Are there some good resources for coming up to speed on SQL Server from Oracle? And what differences will I find as far as SQL commands and structure?

    Thanks,

    Harry

  • March 21, 2014 at 4:20 pm

    #1699274

    The core concepts of relational data storage and database administration are the same. So tons and tons of your knowledge is going to transfer pretty easily. But, the devil is in the details and how you do things is radically different. I helped write a book that was specifically targeted at migrating Oracle (and others) to SQL Server. It could help.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 21, 2014 at 5:52 pm

    #1699283

    As a dual skilled DBA, i say forget what you know about Oracle. Get the SQL server internals book and give it a good going over multiple times.

    I hear so many people say "oh sql server, its just like oracle".

    No, it's like apples and oranges, they're both fruits but very different kinds of fruit.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 7, 2014 at 10:29 am

    #1703878

    If I just want to move a table, or a set of tables, between two servers that aren't able to connect to each other, is BCP the proper tool to use? And am I right in thinking that it's the equivalent of Oracle's exp/imp commands?

    Thanks,

    Harry

  • April 7, 2014 at 1:38 pm

    #1703937

    hboswell (3/21/2014)

    I have recently retired from my previous job as an Oracle DBA, now I'm working for a small IT firm where I'll be doing some SQL Server work - not heavy-duty DBA work, but database creation and data admin stuff. Are there some good resources for coming up to speed on SQL Server from Oracle? And what differences will I find as far as SQL commands and structure?

    Thanks,

    Harry

    This should be a good starting point ..

    http://www.amazon.com/Microsoft-Server-2008-Administration-Oracle/dp/0071700641/ref=cm_cr_pr_product_top

    http://sqlblog.com/blogs/buck_woody/archive/2010/04/28/sql-server-for-the-oracle-dba-links.aspx

    --

    SQLBuddy

  • April 7, 2014 at 1:41 pm

    #1703939

    sqlbuddy123 (4/7/2014)

    hboswell (3/21/2014)

    I have recently retired from my previous job as an Oracle DBA, now I'm working for a small IT firm where I'll be doing some SQL Server work - not heavy-duty DBA work, but database creation and data admin stuff. Are there some good resources for coming up to speed on SQL Server from Oracle? And what differences will I find as far as SQL commands and structure?

    Thanks,

    Harry

    This should be a good starting point ..

    http://www.amazon.com/Microsoft-Server-2008-Administration-Oracle/dp/0071700641/ref=cm_cr_pr_product_top

    http://sqlblog.com/blogs/buck_woody/archive/2010/04/28/sql-server-for-the-oracle-dba-links.aspx

    --

    SQLBuddy

    Is 2012 similar enough to 2012 that most of the book would carry over?

    Thanks,

    Harry

  • April 7, 2014 at 1:43 pm

    #1703940

    hboswell (4/7/2014)

    If I just want to move a table, or a set of tables, between two servers that aren't able to connect to each other, is BCP the proper tool to use? And am I right in thinking that it's the equivalent of Oracle's exp/imp commands?

    Thanks,

    Harry

    Yes. And if the two servers are using the same version/service pack, the NATIVE file type is absolutely the best option. Just understand that it won't actually create the table nor will it move indexes, etc, etc.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 7, 2014 at 3:21 pm

    #1703965

    hboswell (4/7/2014)

    sqlbuddy123 (4/7/2014)

    hboswell (3/21/2014)

    I have recently retired from my previous job as an Oracle DBA, now I'm working for a small IT firm where I'll be doing some SQL Server work - not heavy-duty DBA work, but database creation and data admin stuff. Are there some good resources for coming up to speed on SQL Server from Oracle? And what differences will I find as far as SQL commands and structure?

    Thanks,

    Harry

    This should be a good starting point ..

    http://www.amazon.com/Microsoft-Server-2008-Administration-Oracle/dp/0071700641/ref=cm_cr_pr_product_top

    http://sqlblog.com/blogs/buck_woody/archive/2010/04/28/sql-server-for-the-oracle-dba-links.aspx

    --

    SQLBuddy

    Is 2012 similar enough to 2012 that most of the book would carry over?

    Thanks,

    Harry

    Yes very much, the difference being a bunch of new features in SQL 2012.

    --

    SQLBuddy

  • April 7, 2014 at 3:33 pm

    #1703969

    sqlbuddy123 (4/7/2014)

    hboswell (4/7/2014)

    sqlbuddy123 (4/7/2014)

    hboswell (3/21/2014)

    I have recently retired from my previous job as an Oracle DBA, now I'm working for a small IT firm where I'll be doing some SQL Server work - not heavy-duty DBA work, but database creation and data admin stuff. Are there some good resources for coming up to speed on SQL Server from Oracle? And what differences will I find as far as SQL commands and structure?

    Thanks,

    Harry

    This should be a good starting point ..

    http://www.amazon.com/Microsoft-Server-2008-Administration-Oracle/dp/0071700641/ref=cm_cr_pr_product_top

    http://sqlblog.com/blogs/buck_woody/archive/2010/04/28/sql-server-for-the-oracle-dba-links.aspx

    --

    SQLBuddy

    Is 2012 similar enough to 2012 that most of the book would carry over?

    Thanks,

    Harry

    Yes very much, the difference being a bunch of new features in SQL 2012.

    --

    SQLBuddy

    But those new features are also available in SQL 2012. :hehe:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply