Saturday, 3 November 2012

SQL Server Vs Oracle - terminology difference


This Thursday, while I was having a discussion with team on change the current SQL architecture, one management guy from Oracle background was suggesting to group all the schema with a common name based on the business logic.

It took a while for me to understand that why he wants to keep all the schema from different database to have it in a single name, instead we can keep in the same database and put it in a different instance. Later we understood that as both are talking on different technology the technical terms varies.

Based on that, I thought of writing the terminology difference between both SQL Server and Oracle.