Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • SQL SUM
    The SQL SUM aggregate function allows selecting the total for a numeric column. The SQL SUM syntax is displayed below: SELECT SUM(Column1) F...
  • SQL HAVING
    The SQL HAVING clause is used to restrict conditionally the output of a SQL statement, by a SQL aggregate function used in your SELECT list ...
  • SQL Replication
    SQL Replication term describes a group of technologies allowing information distribution and mirroring between different databases. SQL repl...
  • SQL ORDER BY
    The SQL ORDER BY clause comes in handy when you want to sort your SQL result sets by some column(s). For example if you want to select all t...
  • SQL COUNT
    The SQL COUNT aggregate function is used to count the number of rows in a database table. The SQL COUNT syntax is simple and looks like this...
  • SQL GROUP BY
    The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certai...
  • SQL MAX
    The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column. The SQL MAX function syntax is very sim...
  • SQL IN
    The SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria. THE SQL IN syntax looks like this: SELECT Column1...
  • JSP date example
    &lt%@page contentType="text/html" import="java.util.*" %&gt &lt!-- http://www.roseindia.net/jsp --&gt ...

Wednesday, March 18, 2009

Compare SQL Server and MS Access

Advantages of MS Access

MS Access is a light weight database managements system. Also, it provides it's own designer so that you can generate reports and simple windows applications without using another programming environment.

It is easy to deploy an MS Access database. Just copy the .MDB file to appropriate location and you are done. There is no database attach/detach process.

Which one to choose - MS Access or SQL Server ?

MS Access is ideal only for applications that require very small databases. Even though the maximum database size limit for MS Access is 1 GB, the performance becomes poor if the size grows more than few hundred MBs.

If you expect your application database to grow more than 100 MB in future, you should consider using SQL Server. It may not be an easy task to migrate to SQL Server later. Eeven though SQL Server allow you to import your MS Access database to SQL Server, you will have to do lot of code changes to take advantage of the SQL Server features.

There will be major performance difference between MS Access and SQL Server. If you are writing a critical application where performance is important, then you must consider SQL Server instead of MS Access.

The new SQL Server 2005 Express is a free version and allow copy/deploy feature. You can copy the database file and attach on the fly. It is a good idea to use SQL Server 2005 Express if you cannot afford to purchase SQL Server license. It has much better peformance and features compared to MS Access.

The bottom line is, choose MS Access only for small and non critical applications.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)