Getting into a consulting business has its own set of challenges that I cherish big time. Recently I was consulted by a product team that had some of the best guys in the market. I was surprised why they might need my services. But I had an open mind to go through what they were doing. They were migrating their current application that was running fine in Oracle to SQL Server. My first thought was – “Wow”. Currently enterprises and organizations do think of SQL Server as a viable, competent alternative when it comes to database choice.
Comparison – Logical Architecture between Oracle and SQL Server
Learning is a journey and that is something I love to keep in mind. Even after being so many years in the industry, I don’t stop learning from peers and people around me. This is the best way I can get better at something. I have been writing about the comparisons working with Oracle and SQL Server in the past and I personally thought this was a great way to learn something new by understanding the concepts of something that we always know. The learning is easy when we are able to make an analogy or metaphor as part of our learning. Do you guys ever use a similar approach while learning something that is completely new in your day-today life? Let us learn about Logical Architecture today.
Comparison – Understanding Tables Between Oracle and SQL Server
Oracle has a Heap-organized table which SQL Server calls “Heap”
Oracle’s “Clustered” tables are called “Indexed Views” in SQL Server
Both Oracle and SQL Server have “Partition” & “Temporary” tables
Oracle’s “External” tables are called “Linked Servers” in SQL Server.
Oracle’s “Object” table is called “Table Type” in SQL Server.
Oracle’s “Index-organized” tables are referred to as a “Clustered index” in SQL Server.
Oracle does not have an equivalent/term for SQL Server’s In-Memory OLTP table
And Oracle’s “Hybrid columnar” compressed tables are called “Column store clustered index” in SQL Server.
SQL SERVER – Instance Definition Working with Oracle and SQL Server
During various conferences and user group Meetups I meet tons of new people who keep asking me on a number of topics that can sometimes be challenging for me. In a recent SQL Server Bangalore User Group chapter that I just bumped into an individual who had worked extensively with Oracle and was in transition to moving to SQL Server.
It was never a surprise for me meeting such people. Now this DBA asked me the fundamental difference with how instances are done in Oracle Vs SQL. And he was looking for my advice to when to use what. This was an interesting conversation and I wanted to pen down the same for your future references.
What are the Differences?
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
SQL SERVER – SELECT * FROM dual – Dual Equivalent
This blog post is for all the Oracle developers who keep on asking for the lack of “dual” table in SQL Server. Here is a quick note about DUAL table, in an easy question-and-answer format. What is DUAL in Oracle? Dual is a table that is created by Oracle together…
Read MoreSQLAuthority News – Migrating to SQL Server from Other Database Products
Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white…
Read More