Skip to Content

SQL Server to ASE DB migration

Hi All,

We are planning to do DB migration from SQL Server to ASE.

Source (old Server)

OS:Win 2003

DB: SQL Server 2005

APP: ECC 6.0

Target System(New Server)

OS: Windows 2012

DB: ASE 16

APP: ECC6 EHP 8

We are planning to upgrade using SUM DMO with System Move.

But as per the SUM central note OS should be Windows 2012 or higher if target SAP_BASIS is 750 or above.

With SUM DMO with system move option Import (DB migration) will run on new server, So it will comply the OS prerequisite for target SAP_BASIS 750.

Is this correct or any other approach? Please suggest.

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 16, 2018 at 08:44 PM

    Hi Suresh,

    As per SUM DMO Note 2631152 - Database Migration Option (DMO) of SUM 2.0 SP03, source db needs to be at MS SQL 2005 if target system is on NW Basis 7.50 and MS SQL 2012 if the target NW system is NW Basis 7.51. On the other hand, you will need NW Basis 7.5x for support of ECC/ERP 6.08 (per SAP Note 1554717 - SYB: Planning information for SAP on ASE)

    As such SUM DMO would be the advisable approach - but please determine the target NW Basis release based on the source db version.

    Thanks,

    Madhvi Pai

    SAP Product Support

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Madhvi,

      Thank you for the reply.

      Our Target NW Basis release 750 SP 12.

      is SUM DMO with System move will support current source system which is on windows 2003 and sql server 2005?

      Target System(New Server)

      OS: Windows 2012

      DB: ASE 16

      APP: ECC6 EHP 8

      Target Basis Release: SAP_BASIS 750 SP 12

      Thanks in advance

  • Posted on Oct 23, 2018 at 01:20 PM

    Hi Suresh,

    SUM DMO SAP Note 2631152 - Database Migration Option (DMO) of SUM 2.0 SP03 mentions for target database SAP ASE and source database MS SQL:

    MS SQL 2005 (available on request), or a higher version, if target SAP_BASIS is 750. Therfore please open a custmer ticket on component

    BC-UPG-TLS-TLA in order to request for it.

    Regards Tobias

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.