Skip to Content
avatar image
Former Member

Moving from Oracle do SQL Server

In my SAP instalation we are thinking to move from SAP/Oracle to SAP/SQL Server.

What do you think about this ?

The reason for this move is we have more knowledge in SQL Server Than Oracle.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Mar 11, 2008 at 08:28 PM

    Check

    http://service.sap.com/osdbmigration

    For production system you will need to (pay) a certified migration consultant.

    Apart from that you can use the system copy guide to do the copy (http://service.sap.com/systemcopy).

    Migrations of databases and/or operating systems is supported.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 12, 2008 at 12:07 AM

    Hi Rui,

    although present knowledge is a strong argument consider these points:

    - today knowledge about other dbms is relatively cheap to acquire

    - the current knowledge will likely be outdated soon and addtional training costs will come up, regardless if you switch the platform or not

    - with MS SQL you're moving into a partial lock-in situation as only windows is available as a platform both for the db server and client in SAP environments. Quite often customers have the need of accessing data in a MS SQL database from let say an AIX based SAP installation and need to install an additional application server on windows for this.

    - the license fee share for MS SQL installation is not less than for Oracle installations - for MaxDB installations it is.

    In any case - a platform switch is always a large project and should only be done if it is really feasible.

    Hope that gives something to think about.

    KR Lars

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2008 at 11:28 AM

    Hi,

    you have to consider also the workload that you will have in the SAP system.

    As Lars stated: with ORACLE you are OS-system independent (quite) and you invest into the future with getting to know ORACLE.

    I don't want to step into ORACLE/Microsoft discussions and both databases have their place but in heavy-load environments I would prefer ORACLE.

    For a good MS SQL DBA it should take less time to get the knowledge as for a beginner.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Bernd,

      your RAC for SAP experience sounds very good. Would you please share some information about your environment with me: OS, database size etc ..

      regards

      Barthez