Difference between Oracle & SQL Server at high level.

Question

Difference between Oracle & SQL Server at high level.

saurabh.deshpande

SSCommitted

Points: 1738
More actions
October 5, 2010 at 11:22 pm

#227309

Hi All
What are the difference between Oracle(Say Oracle 10g) and SQL Server (Say SQL Server 2005) at high level.
Thanks

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

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

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

saurabh.deshpande (10/5/2010)
What are the difference between Oracle(Say Oracle 10g) and SQL Server (Say SQL Server 2005) at high level.

Too many differences - this exceeds what can be discussed in a single forum thread.

Since this is a SQL Server forum I'm assuming poster is familiar with this platform so I'll mention just five differences that pop to the top of my mind from the Oracle point of view...

1- SQL Server does not run on Unix/Linux/AIX

2- Table/Index partitioning handling

3- Cursor handling

4- SQL Server does not has anything similar to Oracle RAC

5- Bitmap indexes.

Hope this points you in the right direction.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 2

Thanks paul

Recently, I start working on the SQL Server of Version 2005.

Can we keep this post open, so that everyone can write, the differences they found while working on these two platforms. Or you can more in list.

Thanks

Saurabh

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

saurabh.deshpande (10/6/2010)
Can we keep this post open, so that everyone can write, the differences they found while working on these two platforms. Or you can more in list.

You own the thread so certainly you can keep it open.

Quick question... what are you planning to do with such a "list"?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 4

Actually, I am intracting with mulpital RDBMS during my assigments.

So, I thought of building Competency within mulpital database systems.

So, you can say finding out the differences is first step toword this.

Any thought from you on this will be helpfull for me.

Thanks

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 5

saurabh.deshpande (10/6/2010)
Actually, I am intracting with mulpital RDBMS during my assigments.
So, I thought of building Competency within mulpital database systems.
So, you can say finding out the differences is first step toword this.
Any thought from you on this will be helpfull for me.

If you are serious about learning Oracle you can download Ora11g - it's free for educational purposes, install it in a home computer and start playing around. Like replicating in Oracle a project you have in SQL Server.

Oracle documentation is also free and available over the internet.

Good luck.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 6

that true, I finished my OCP (DBA Track). that's not problem

yes, in case of SQL Server Or DB2, I am exploring it.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 7

saurabh.deshpande (10/6/2010)
... I finished my OCP (DBA Track).

Being both a SQL Server DBA and an Oracle OCP you should know what the differences are, don't you? 😉

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

saurabh.deshpande SSCommitted Points: 1738 More actions · Answer 8

🙂 I said, I am just OCP Oracle, not a SQL Server DBA.

I am not into Database administration.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 9

saurabh.deshpande (10/6/2010)
🙂 I said, I am just OCP Oracle, not a SQL Server DBA.

I'm sorry, my bad. I missunderstood - it happens to me 🙂

saurabh.deshpande (10/6/2010)
I am not into Database administration.

Now I'm really confused 😀

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.