Skip to Content

My first Sybase ASE migration experience

As a Certified Migration Consultant and a SAP Partner, we decided to work on Sybase ASE to get experience on SAP’s new database.

SAP released Sybase ASE Kernel for specific SAP versions. Supported SAP solutions are:

  • SAP ERP 6.0 incl. EHP5 based on SAP NetWeaver 7.0 EhP2
  • SAP CRM 7.0 incl. EHP1 based on SAP NetWeaver 7.0 EhP2
  • SAP SRM 7.0 incl. EHP1 based on SAP NetWeaver 7.0 EhP2
  • SAP SCM 7.0 incl. EHP1 based on SAP NetWeaver 7.0 EhP2
  • SAP NW 7.0 incl. EHP2
  • SAP Solution Manager 7.1 SR1

You also need the specific Kernel, Installation Master and Sybase ASE RDBMS DVD’s for Installation and Migration to Aybase ASE Database.

Our Accounting System is running on Windows 2008 R2/SQL Server 2008 R2 with version ERP 6.0 EHP5 SP10 and 54 GB Database size. We decided to do a migration to Windows 2008R2/Sybase ASE 15.7 and here I’ll share my first experience with Sybase ASE.

Planning

First of all, we needed to check the compatibility of our source system with the target and find out that all conditions are met.

Source Platform Is it ok for ASE Migration?
SAP Solution and Release SAP ERP 6.0 EHP5 Yes
SAP Basis Release and SP Level BASIS 7.02 SP 10 Yes
Operating System Windows 2008 R2 SP1 x64 SE Yes
Database SQL Server 2008 R2 x64 SE Yes
Database Size 54 GB

Preparations

  • Downloading ASE related DVDs mentioned in Note 1591424.
    • 51041592 SAP Business Suite 2010 Installation Master Sybase GA

    • 51041595 SAP Kernel 7.20_EXT for BS7i2010 Sybase GA

    • 51041596 Sybase Adaptive Server Enterprise 15.7 RDBMS GA

  • Download the ASE, SAP Kernel and ASE ODBC Client Updates to meet the minimum version requirements mentioned in note 1591424. They’ll be installed during migration.

Source System Export

We started the source system export with source system’s Installation Master DVD (in our case it is 51041254 BS7i2010 Installation Master Windows Server on x64 64bit)

It is normal export process, nothing new

Target System Installation with Export Data

We started the Import on target system with Installation Master for Sybase ASE and suprise 😛

There is no option for migration / system copy under ERP 6.0 EHP5 Tree. You can only use the NetWeaver 7.0 EHP2 Migration options (which are same in fact)

/wp-content/uploads/2012/06/sapinst_erp_108731.png

/wp-content/uploads/2012/06/sapinst_nw_108732.png

As usual, for ASE SAPINST asks for datafile placement

/wp-content/uploads/2012/06/ase_datafile_108733.png

And asks master password for Database users (sapsa, sapsso, SAPSR3)

And also the migration key. But the standart migration key given in Note 1339717 – Hom./Het.System Copy SAP NW 7.0 incl. EHP 2 doesn’t work.

You’ve to apply for Migration key via http://service.sap.com/migrationkey

/wp-content/uploads/2012/06/migkey_108734.png

The rest is almost same as other migrations.

During installation, Sybase ASE is automatically installed by SAPINST like DB2 (Oracle and SQL Server must be installed seperately and manually 😎 )

And 2 OS services installed (for Windows of course). These services can be used to restart ASE DB.

/wp-content/uploads/2012/06/ase_services_108735.png

Before Import, you’ve to update the SAP Kernel, R3load, Sybase ASE RDBMS and ASE ODBC libraries. For this you’ve to stop the SAPINST before ABAP Import. In my previous blog TIP: How to stop OS/DB Migration before Import Phase? I mentioned a way and community added the others.

For updating, you’ve to follow instructions given in SAP Notes + plus some tips from Sybase Community. I’ll write a second Blog on ASE Administration Tips.

Result

After migration, database size growth was suprised me. Here is the result:

Source Platform Target  Platform
SAP Solution and Release SAP ERP 6.0 EHP5 SAP ERP 6.0 EHP5
SAP Basis Release and SP Level BASIS 7.02 SP 10 BASIS 7.02 SP10
Operating System Windows 2008 R2 SP1 x64 SE Windows 2008 R2 SP1 x64 SE
Database SQL Server 2008 R2 x64 SE Sybase ASE 15.7
Database Size 54 GB 105 GB

We’re still discussing the reasons for DB size growth on the discussion Maximum DB size for SAP on ASE?

But here are the brief lessons learned during migration;

  • Sybase ASE is automatically installed by SAPINST
  • Sybase ASE update required some manual commands and script executions
  • Command line management is easy
  • Some Important System Parameters can be modified on-the-fly (dynamically)
  • Standart Migration Keys given in SAP Notes are not working
  • Database size grows twice of SQL Server 2008 R2 size although both supports PAGE compression (We’ll investigate this case with SAP and update with comment to this blog)
  • DBACOCKPIT (Webdynpro ABAP based) interface is used to monitor and manage Sybase ASE Database
  • There are some interface problems exists on DBACOCKPIT
21 Comments
You must be Logged on to comment or reply to a post.
  • Hi Huseyin,

    You have very nicely explained the steps of the migration. I am also in the initial stage of a similar project. But I have upgrade (from ECC 5 to ECC6 EHP5) along with the migration of Oracle 10g to Sybase.

    Should I do the migration first from Oracle to Sybase and then the upgrade or the other way?

    Any suggestions would be of great help.

    Regards

    Ivan

  • The challenge is when you have to migrate to ASE a source database, let's say, larger than 2-5 TB, when you have to configure the ASE database for import, configure import_monitor, post import db activities (configurations), etc. Downtime might be critical for some customers. For example, how long did your update statistics run for 100 GB target database?

  • Hi Huseyin,

    I want to do a Migration from oracle to Sybase ASE.

    Like you I have downloaded the Inst.Mast. DVD, but when I execute sapinst I don't find the ASE database into the target system selection.

    Have you had same problem?

    Other question: My source system is ERP6.0 EHP5 sp8 but it is a non unicode system. Is it a problem?

    Can you help me please?

    thanks in advance

    Emilio

    • Hi Emilio,

      For export, you've to use your versions regular INstallation Master DVD for export. You'll not be able to see the Sybase ASE in Target Database options in that DVD. For Import, you'll use another DVD (51041592 SAP Business Suite 2010 Installation Master Sybase GA). There you'll see Sybase ASE as target database.

      Target System (where ASE will be the DB) must be Unicode. During migration you've to combine the Unicode Conversion or alternatively do the Unicode Conversion on your existing system before ASE Migration. Not as it requires export/import, doing UC conversion during ASE migration is the best way in your case.

      Regards

  • Hi Huseyin,

    Could you tell me what steps should I follow to generate the export, have an install ERP 6.0 EHP5 SAP_BASIS SP7, already did export to version MaxDB, MS-SQL to put logs in error at the time of import. Is there anything I should do in Source?

    Tks for your help

    • Hi Rodrigo,

      Duing Export, I used the IM mentioned above and selected MaxDB as the target DB. There is nothing you've to do in Source System if it meets the min. versions&SP's (It looks OK) and if it is Unicode.

      • Hy Huseyin,

        I found the note "1716201 - SYB: Update control.xml files for installation on Sybase ASE" that informs you that the SAPInst available with this problem because some files are outdated and asks to change some files, including control.xml. I asked for the note and the import is running successfully.
        Thanks for your response and explanation of how to do!

        Rodrigo

  • Hi Huseyin,

    Good blog and thank you for sharing.

    I am curious, did SAP get back to you on the database size difference?

    Interested to know what may have caused the almost double size difference.

    Also, do you currently use one big sapdata_1 to store the whole 105GB or did you split it into multiple sapdata_n? I did not see an option to create additional sapdata_n in SAPINST. I assume we would need to do it using isql after the installation.

    Thank you.

    • Hi Kevin,

      Sure they did 🙂

      I'll write another Blog about the update and some clarifications. Please wait until I do the second Migration.

      For Datafile, yes you've to add additional datafiles via isql after migration.

      • Hi Huseyin,

        can you share with us the answer from SAP regarding the unusual growth of Sybase database whe you did the migration from SQL, we're making the migration too and want to avoid that problem

      • Hi Huseyin,

        Btw, just to share with you (and others) on the datafiles.

        If you create multiple folders before starting SAPINST for \sybase\SID\sapdata_n (e.g. \sybase\SID\sapdata_1, \sybase\SID\sapdata_2, etc), the SAPINST will be able to pick it up and you can define the space during installation. 🙂

  • Hi Huseyn,

    Do you have any update about database size growth? It's an important point to be aware on our Sybase projects.

    If you perform database compression after installation/migration, I assume that the benefits are miserables, because the compresion is already being done during the process. Am I right?

    Did you get any answer from SAP?

    Thanks and REgards

    Pau