Please help me pick the correct database.
I am looking for the best database to use with my .Net application. Most of the reading that I have done is the marketing propaganda. Looking for some advice from people that have used the products.
The database is for a .Net client application (VS 2005).
The primary use will be for a single user but 30% of the time it will be in a multiuser environment. Thus multiple doing updates at the same time.
Low volumn of data. 5 - 10 meg per instance.
Proably just 3 - 5 tables very simple joins to retrieve the data.
I do not what a normal user to be able to 'manage' this database thru anything but my application.
Royality free distribution is a must.
I have looked into XML/Datasets but from what I have read those are not a good idea in a multiuser invironment. I have used SQL Server 2000 in a server environment for year but have not work with the express edition of 2005.
Thanks for your recomendations.
The database is for a .Net client application (VS 2005).
The primary use will be for a single user but 30% of the time it will be in a multiuser environment. Thus multiple doing updates at the same time.
Low volumn of data. 5 - 10 meg per instance.
Proably just 3 - 5 tables very simple joins to retrieve the data.
I do not what a normal user to be able to 'manage' this database thru anything but my application.
Royality free distribution is a must.
I have looked into XML/Datasets but from what I have read those are not a good idea in a multiuser invironment. I have used SQL Server 2000 in a server environment for year but have not work with the express edition of 2005.
Thanks for your recomendations.
I think you already have the best answer included in your question... SQL Server 2005 Express Edition (formerly MSDE). You talk to it through code just like 'grown up' SQL Server, it's free to use, distribute, etc. By default, it doesn't come with Management Studio, but you can install it to talk to the db. For the very small volume of data and users, it will work fine. You can always upsize to full SQL Server if the usage patterns grow dramatically. As you evaluate, make sure you consider deployment / install. It shouldn't be a problem, but is worth looking into.
ASKER
With past applications that we have writen and used the MSDE, we were very disapointed with how many resources the MDSE used. Can you give me an indication (realitive to the MSDE) how light or heavy SQL Express is? One last thing related to the Express... do you get a icon in the system tray that tells you it is running or does that not apply to Express 2005? I would prefer the database to be completely hidden from the users.
Thanks
Jon
Thanks
Jon
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks for the help.