Manjunath Ram Venkat

Welcome to my Blog… On PowerPivot, SQL Server 2012, Business Intelligence, MSBI

Difference between SQL Server and Oracle and Mysql and IBM DB2 and MS access

3 Comments

I was very enthusiastic at some point of time to create my own database but the biggest hurdle as in this case and for anything for that matter was “I did not start”. Anyways I want to thank myself for having not started this. Because some how I sensed that I may get a chance to know about most of the databases in future.

So Eventually I could come across the databases in the order on how I could learn them MS Access 2.0, 97,2000,2003,2007,2010, SQL Server (2000,2005, 2008 R2, 2012(In-Process at the time of writing this Post)), Oracle, MySQL, IBM DB2.

So I had developed an Internal document with comparison of all these databases with respect to various aspects such as The Operating System,Fundamental of RDBMS,Interface,Data Size Limits,Database Capabilities,Data Types,Other Objects,Partitioning,Access Control Functionalities, Functions, Comparison Operator, Case Sensitive, Pattern Matching,  Identity Column,Comment,Characters,Concatenation,Date Specifier and Keyword.

Feel Free to download the Comparison spread sheet from clicking the link below.

Databases_Comparison_By_ManjunathRV

Please let me know if there are any changes required.

Good Luck. Cheers.

Author: manjunathrv

aah Just another Developer...

3 thoughts on “Difference between SQL Server and Oracle and Mysql and IBM DB2 and MS access

  1. Reblogged this on Sutoprise Avenue, A SutoCom Source and commented:
    I recommend everyone who has concerns on what databases can and cannot due to read on and check out Manjunat’s spreadsheet. Excellent job!

  2. Is there eny difference between them?

  3. I don’t know if it’s just me or if everyone else experiencing issues with your
    blog. It appears as if some of the text in your content are running off the screen. Can somebody else please comment and let me know if this is happening to them as well?
    This could be a issue with my browser because I’ve had this happen previously.

    Appreciate it

Leave a reply to SutoCom Cancel reply