Skip to Content

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.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

      1. 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 ..:)

        (0) 

Leave a Reply