Skip to Content
avatar image
Former Member

Migration from Oracle to MaxDB

Hi All,

We want to migate from Oracle to MaxDB.

What are the possible test or procedures can do before migrating.

Also are there any tools through which we can use to test the performances of both the systems and compare.

I mean to load testing or something like that.

Please help.

Regards,

Vikas Madaan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 05, 2008 at 07:45 AM

    > We want to migate from Oracle to MaxDB.

    Good decision! 😊

    > What are the possible test or procedures can do before migrating.

    >

    > Also are there any tools through which we can use to test the performances of both the systems and compare.

    >

    > I mean to load testing or something like that.

    What you really should do is to order the Migration Service for MaxDB.

    See this Wiki-page [MaxDB Migration Support Service|https://wiki.sdn.sap.com/wiki/x/dFo].

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2008 at 10:59 PM

    Hi Vikas

    The heterogeneous copy documentation does have all the information you will need to get started.

    We have almost completed our migration of all our SAP instances from Oracle to MaxDB. For the performance comparison, I have only allocated the same memory to MaxDB as was allocated to Oracle 10g (SGA+PGA) and we have found the performance to be excellent so far. We will be migrating the Production ECC in December which is the big test.

    To do load testing you will need a 3rd party product like LoadRunner. We didn't perform any load testing or benchmarking so I can't help you with figures there.

    My only complaint with MaxDb is documentation. There is plenty of SAP Help style documentation but nothing concise yet. Christiane's book, SAP MaxDB Administration is not going to translated to English in the foreseeable future according to someone at SAP Press. Hopefully they will change their minds.

    Regards

    Doug

    Add comment
    10|10000 characters needed characters exceeded

    • > Performance is one of the major concerns when doing a change of the DBMS platform with SAP.

      > In general the design of NetWeaver does all the DBMS abstraction - so technically the ABAP will work on either platform.

      My impressions is: All new products (be it CRM, SRM or whatever is newer than software released after year 2000) works flawlessly.

      When our MaxDB grew (actually almost 2.2 TB) we had performance issues in the (I call them) "legacy modules" (FI, AM, MM and CO) but 99 % of those problems were known and could be fixed quite easily by creating secondary indexes. I

      > What it cannot do is tune the statements so that the performance will be optimal.

      > This is what the service is about.

      And I believe that exactly that experience (and more) is contained in the migration service. If we would do a migration nowadays I would book that service, you can avoid lots of known performance issues because the people doing that service know the database for a long time.

      Just my EUR 0.02

      Markus