Skip to Content
Author's profile photo Nilutpal Sharmah

SAP on SQL—— A very end user friendly combo pack.

Hello ,

In layman language, I found MS SQL very user friendly in SAP environment which tackles most of all the database administration things automatically. By bench-marking with SAP with oracle, I got following major positive points, which are being handled automatically without any manual intervention :-

1. We don’t need to check the table space .

2. No need to maintain Archive log mode — ON /OFF  which generally leads to full the archive directory .

3. No need to do statistics update manually .

4. Upgrade is also comparatively easier than oracle.

I have raised all above points based on my perception , so there may be some ambiguities which I would like you to suggest for correction, so that we can get to a bottom line of the topic being discussed over here.

And of course,  there are many advantages are also there for oracle and other databases, but all mentioned points only subjects to past experience. Request you all to update on this to make a valuable blog.

With Thanks,

Nilutpal.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      Hi Nilutpal,

      Good to know you have nice experience with SQL Server!

      Regards,

      Eduardo

      Author's profile photo Nilutpal Sharmah
      Nilutpal Sharmah
      Blog Post Author

      Thanks !!

      Author's profile photo Nibu Antony
      Nibu Antony

      Hi Nilu,

      Its been long time since I worked with MS SQL . But I feel as below:

      1. We don't need to check the table space

      Obviously  you need to check the datafile size and maintain . It can be via SQL studio , and you may have to increase the size or add other files etc .

      2. No need to maintain Archive log mode --- ON /OFF  which generally leads to full the archive directory .

      There is a concept of transaction log, same as that of archive log file in Oracle. There are different modes like SIMPLE,BULK,FULL etc in place of archive ON/OFF in oracle .

      3. No need to do statistics update manually .

      Statistics update is there for SQL DB and more over there are few jobs like CHECKDB etc you need to run in regular basis .

      4. Upgrade is also comparatively easier than oracle

      Agree.

      Oracle is a DB developed by  a company who primarily focuses on  Database technologies  and MSSQL is the one developed by an OS vendor, that difference is always there ..:)

      Author's profile photo Nilutpal Sharmah
      Nilutpal Sharmah
      Blog Post Author

      Thanks Antony.. Your feedback is really appreciated !!

      Rgds,

      Nilutpal.

      Author's profile photo Former Member
      Former Member

      Hi Nilutpal,

      Good information explained.

      Regards,

      Omkar