locked
Can one DBMS be used for desktop and web application? RRS feed

  • Question

  • I want to use SQL Server 2005 Express Edition for my desktop VB.NET application.  But I would also need this desktop data in a web application.  Can I use my SQL Server 2005 Express database as my web database?  

    If not, here are my questions:

    1)  Can you suggest a good web database?
    2)  How can desktop data be used/shared for web application?  Is that possible?  If possible, I want to use only 1 DBMS for my desktop and web applications.

    Thank you.

     



       

    Saturday, May 23, 2009 10:52 PM

Answers

  • I am not sure i understood the probelm correctly.  SQL Server express is being used for both web and desktop kind of application extensively. There is no problem as such. Only thing is that , SQL Express has some limitation from DB Size(4 GB Max) and memory and other resource utilisation prespective. If the db size is going to be more than 4GB or if it is highly transactional or need high resouces then go for a full version of sql server


    Madhu
    MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/
    Sunday, May 24, 2009 1:22 AM

All replies

  • I am not sure i understood the probelm correctly.  SQL Server express is being used for both web and desktop kind of application extensively. There is no problem as such. Only thing is that , SQL Express has some limitation from DB Size(4 GB Max) and memory and other resource utilisation prespective. If the db size is going to be more than 4GB or if it is highly transactional or need high resouces then go for a full version of sql server


    Madhu
    MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/
    Sunday, May 24, 2009 1:22 AM
  • Just as an addition, there is no need at the beginning to decide one or the other if you are not sure about the workload of your database you can start using SQL Server Express and port the database lateron to an greater edition of SQL Server. The backup as well as database files are compatible (there is no difference in the structure) and can be used vice versa (If you are using certain enterprise features like compression, the backups and database files might not be downwards compatible)

    -Jens


    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    Sunday, May 24, 2009 10:48 AM