SAP ERP 6.0 EhP x with SYBASE ASE 15.7 or MS SQL SERVER ?

[Former Member]

Hello

We plan to change our SAP architecture (upgrade + DB migration), current SAP system (ERP 6.0) are based Oracle 11gR2.

SAP Database strategie move to Sybase ASE but MS-SQL server simce to be a good alternative.

Many benchmark are available on Oracle / Sybase ASE but  nothing regarding MS-SQL Server vs Sybase ASE in SAP context.

I'm looking for feedback in between MS-SQL Server vs Sybase ASE for SAP or any argumentation to improve our choice.

thanks for your support

Regards

Eric MOUREY

[Former Member · Accepted solution]

Eric,

I do not have the experience to compare SAP performance between SAP running on ASE and SQL Server.  However I have in depth experience of ASE and SQL Server; including spending a couple of years working on Sybase to SQL Server migrations for various clients.

If I put aside the SAP application for a moment and look at ASE and SQL Server. 

• I'd guess you are aware of the history of SQL Server/Sybase  - SQL Server 4.2 was line for line Sybase 'ASE' 4.2 (MS effectively purchased the code)
• Even now (SQL Server 2005 was a bit step change for SQL Server) they have many logical similarities  (i.e. locking; T-SQL)
• SQL Server has some great features that I'd love to see in ASE (i.e. 'Database snapshots')
• ASE has some great features I'd like to see in SQL Server (i.e. 'In memory databases')
• They are both 'good' products - i.e. they can both perform well
• However ASE seems to have certain functionally that is aimed at the higher end of Enterprise Class computing (i.e. multiple tempdbs)
• In my 20 years working with Sybase ASE it's proved ti be an extremely robust, and stable product

Now lets throw SAP into the mix :-

• Sybase ASE is an SAP product.  
• ASE/SAP has a merged release cycle
• One vendor - one support call
• I would expect significantly reduced license costs - even against SQL Server (which is generally competitive against Sybase ASE)
• I expect SAP to utilize key functionaly in ASE for performance/scalability - the ASE license for SAP utilizes all the options in ASE - so we may well see SAP utilizing In Memory Databases at some point
• Of course other 'SAP Sybase' products are becoming key to SAP - notably Replication Server and IQ.  So consider the impact of tight integration with these in the future

I'd go ASE.

Any more questions please get in touch.

[Former Member · Accepted solution]

Hello Chris

Thanks a lot for this answer

Regards

Eric

[mqaiser · Accepted solution]

Hi Chris,

Great explanation about Sybase functions , however I was looking for feature like MS SQL  log shipping feature using Studio which we don't have in Sybase. Any Idea SAP is going to provide this in future ???

Thanks

Mohammad

[tilman_model-bosch · Accepted solution]

There is not ready to run implementation of loggshipping for Sybase ASE. 😞

But loggshipping is possible of course.

Have a look at SAP note 1650511 - SYB: High Availability Offerings with Sybase ASE

HTH

Tilman Model-Bosch

[Former Member]

Hi Eric,

I am Sybase DBA and also admin for some SQL server,  Both have some common features, but I would like to add Sybase ASE is more  robust compare to  MS SQL server, very stable and durable.

Latest 15.7 version has great features.

I would suggest you for Sybase ASE, and by using its Replication server you can move/fetch  data from  any other vendor database .

Rest choice is yours !

AnVa

[surendra_battula]

good day

we r having a data migration from oracle to sybase ase. can u please suggest me as a sap abap developer what would be my role. so I can start working on it.

this would help me a lot. thanks in advance

[tilman_model-bosch]

Surenda,

A general answer to a a general question:

If your ABAP code adheres SAP best practice for ABAP coding - there should be little for you to do.

Open SQL in ABAP is designed to run on any DB.

If you coded optimised for Oracle or use Oralce specifc features (e.g. EXEC SQL) you will have to review and change that code.

Rgds

Tilman

[Former Member]

Hi Eric,

We will recommend to go for Sybase ASE 15.7.101.

Sybase is also easy maintenance and good performance.

Next coming years SAP may stop all databases.

Regards,

Sivarajesh.