Migrating from SQL Server to Oracle Series

Migrating from SQL Server to Oracle Series

In this series, SQL Server expert Joe Lax will be describing the steps he takes to learn Oracle database administration. Included are editorials, book reviews, and technical articles that chart his course. The content will develop along with Joe’s migration journey, so think of it as a continual work in progress.

In the last several years, I have built and expanded my career based on my knowledge of Microsoft SQL Server. However, I am in the process of learning more about the flagship product of Microsoft’s chief rival: Oracle.
Read on…

Oracle Has SQL Server Beat in Stored Procedure Programming
Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processes?SQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.

Concurrency Handling in Oracle: Preventing Locked Data
SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to “dirty reads.” Find out how it works.

Storing Your Data in Oracle
Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Joe Lax shows you how locally managed tablespaces can let the database engine make most of the decisions for you.

Oracle Basics: Querying an Oracle Database
Oracle’s SQL*Plus is no SQL Server Query Analyzer, but with a little practice you’ll get the hang of it. Joe Lax shows you how to survive your first Oracle query with your dignity intact.

Oracle Concepts: The Instance and the Database
The complexity of how information is stored and where it is retrieved from is hidden from the casual user who queries a database. But if you plan on administering Oracle, you need to become familiar with how Oracle handles both resources. In this article, Joe Lax discusses two basic, but important, concepts with regard to memory and disk?the “instance” and the “database.”

Joe Lax has spent the last 10 years working in various database environments and has been a practicing DBA on all versions of SQL Server from version 4.2 onward. Joe is also a MCSE and an MCT. Recently, he has started to learn Oracle, which affords him no end of fun. Reach him by e-mail .

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist