locked
What to choose SQL Server or MS Access

    General discussion

  • Hello everybody. 

    I am a manager in a pharmaceuticals company. Currently we are using MS Access to store sales and stocks data. Now we are deciding to migrate to MS SQL Server, but we do not know the features and advantages of the database over MS Access. We are also planning to extend the features of the database. Could you please help us decide? 

    I am sorry if the questions are too simply, but wanted to know opinions of the professionals. 

    Thank you in advance.
    Tuesday, December 08, 2009 4:15 AM

All replies

  • KarimB,

    This forum is reserved for discussions about the use of SQL Server 2005/2008/Express in Office Communications Server 2007.


    It would perhaps make sense for you to post your question directly to the SQL Server Forums and Blogs at:

    http://www.microsoft.com/sqlserver/2008/en/us/forums-blogs.aspx


    Hope this helps. Thanks.
    TechNet Forum Moderator - http://www.leedesmond.com
    Thursday, December 10, 2009 2:12 PM
    Moderator
  • How many users are you looking to support? How much data are you talking about when you mention "sales and stocks" data? These items will be a big component to making your decision.

    Jim Guy MCP, MCITP EA, CCNA, CEH Systems Administrator Kirkland, Washington
    Thursday, December 10, 2009 7:05 PM
  • You are already using MS Access. Your decision to upgrade to SQL Server should be based on these factors -
    1. Is your organization at a stage (or will be soon) where the cost-to-benefits ratio of some of the following enterprise class features of SQL Server really makes sense?
      - ability to store/retrieve large volume of data (we are talking about multiple GBs at least)
      - robust security features
      - scaling up/out for future growth
      - ability to support multiple concurrent users
      - ability to support web/desktop/reporting based applications to make data accessible to these users
    2. Is the organization ready to pay lot more money in hardware/software/development/maintenance costs (when compared to MS Access) to take advantage of the above features?
    3. Is this acceptable that the business users (I�??m not talking about the technical staff) would need some time for transition and training on the new application(s) or reporting tools?
     
     
    "KarimB" wrote in message news:0f0ec0b4-f61f-42a2-b868-41319467a244@communitybridge.codeplex.com...
    Hello everybody. 

    I am a manager in a pharmaceuticals company. Currently we are using MS Access to store sales and stocks data. Now we are deciding to migrate to MS SQL Server, but we do not know the features and advantages of the database over MS Access. We are also planning to extend the features of the database. Could you please help us decide?
     
    I am sorry if the questions are too simply, but wanted to know opinions of the professionals.
     
    Thank you in advance.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.
    Thanks!
    Aalam | Blog (http://aalamrangi.wordpress.com)
    Monday, December 31, 2012 6:59 AM