Skip to Content
Author's profile photo Hüseyin Bilgen

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

Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ivan Martis
      Ivan Martis

      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

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      Hi Ivan,

      Sybase ASE is only supported with ERP 6.0 EHP5. So you've to first do the upgrade and then migration to Sybase ASE.

      Kind Regards

      Author's profile photo Ivan Martis
      Ivan Martis

      Hi Huseyin,

      Thanks for the valuable information.

      Regards

      Ivan

      Author's profile photo Srinivas Siruvari
      Srinivas Siruvari

      Hi Huseyin,

      Thanks a lot for the valuable info on Sybase.

      We are trying to install NW7.0 EHP2 on sybase.  I went through this note get more details.

      Note 1606654 - SYB: SAP Business Suite 7i2010 on Sybase ASE

      Now I am trying to find the  installation media for NW7.0 EHP2. but with no luck.

      Do you know the exact path to locate these DVDs?

      Also do you know if GRC add-on is supported on Sybase?

      Thanks,
      Srini

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      Hi Srini,

      It is under normal NetWeaver Installation path. See pics below

      oppps, I reached to the max. allowed pic limit in this blog I guess.

      So please check the images via following links

      https://www.sugarsync.com/pf/D448156_7543774_166283

      https://www.sugarsync.com/pf/D448156_7543774_166281

      If you cannot see as I can see, then probably Sybase ASE is not enabled to you due to licensing issues.

      Regards

      Author's profile photo Srinivas Siruvari
      Srinivas Siruvari

      Hi Huseyin,

      Thanks for the information. I was trying under regular Netweaver installation path only.

      I guess we are not licensed to download Sybase as I could see oracle only.

      Thanks for your help.


      Srini

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      Hi Srini,

      Yes as you don't have license, you cannot see it.

      Author's profile photo Former Member
      Former Member

      Hi Srinivas,

      If you are referring to GRCFND_A and GRCPINW then we have both on system running on ASE.

      Author's profile photo Former Member
      Former Member

      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?

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Kevin Ooi Wen Chong
      Kevin Ooi Wen Chong

      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.

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      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.

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Kevin Ooi Wen Chong
      Kevin Ooi Wen Chong

      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. 🙂

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      Hi Kevin,

      Thank you for clarification. We expect that SAP will provide a beautful way like they did for other DBs 🙂

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Hüseyin Bilgen
      Hüseyin Bilgen
      Blog Post Author

      Hi everyone,

      sorry for delay but now I finished the second migration tests with good updated informations.

      Please check my second Blog about My 2nd Sybase ASE Migration.