SAP OS/DB Migration to SQL Server - FAQ
Published Mar 13 2019 08:35 AM 672 Views
First published on MSDN on Jul 05, 2010

How to Greatly Speed Up Migrations from Oracle/DB2 to SQL Server

Microsoft has developed some techniques to greatly speed up the process of converting from UNIX/Oracle/DB2 and AS/400 & Mainframe to Windows/SQL Server.

1.        Why do customers Migrate to Windows/SQL Server?

The majority of customers who migrate legacy UNIX/Oracle/DB2 systems to Windows/Intel/SQL Server do so for cost reasons.  Typically customers reduce their SAP platform costs to at least one quarter the cost of a UNIX platform (a saving three quarters).

Typically very large customers save even more when the costs of DR centers and other costs are factored in.  Another benefit is a huge improvement in performance.  Modern Intel systems deliver extremely good performance at a very low cost.

In recent years Intel based systems have incorporated the RAS features once only found on high cost proprietary UNIX hardware.

2.        Are there Case Studies of Customers Saving money by migrating to SQL Server?

Yes, there are a large number of public case studies.  In addition there are an even larger number of customers that have migrated to SQL Server.  Microsoft cannot make a case study for every migration.

Unilever North America

CSR Australia

Queensland Railways Australia

Arcelik Turkey

Lockheed Martin USA

There are many SAP partners who perform OS/DB Migrations including HP & RealTech

3.        How to Migrate from UNIX/Oracle/DB2 to SQL Server?

SAP provide tools free of charge to all SAP customers to unload all the data and configuration from a SAP system and reload this into SQL Server.  The tools are R3LOAD and JLOAD (for Java).

The attached document describes Microsoft recommendations for migrations to SQL Server.  Detailed information can be found in this document.

If you have any questions please post them in this blog.

Oracle to SQL Migration FAQ -v2.6.pdf

Version history
Last update:
‎Mar 13 2019 08:35 AM
Updated by: