I have read many posts regarding MSDE usage. Unfortunately many of them are old (2002 and up). MS now has SQL Expres (2005).
I am 3/4 finished with (1) re-distributable application that will probably have no more than 5 users concurrently where I am implementing MSDE 2000. However, I will be starting on another re-distributable application in the same market that will take advantage of 80% of the data structure, forms and reports previously written in application #1.
My problem is that the amount of data may increase exponentially and the number of concurrent users may double or triple. The key word is MAY. I don't want to initially lock myself into having to raise the price of my #2 application for full-price SQL Server because of database size and/or performance. I understand the 2gb limitation of the MSDE database. Unfortunately, economics is a driving force in marketing this app. Fair amount of competition.
Many of the links found on the Expert postings regarding performance issues, licensing, etc. refer to MSDE 2000 and those links aren't available anymore now that MS is pushing SQL Express/Server 2005.
I feel that I am at a crossroads in my development and need to decide several things before moving forward:
1) Do I stick with MSDE 2000 or do I look at another database like mySQL (considerably cheaper)?
2) Do I stick with MSDE and upgrade to 2005?
3) Where do I find some correct information on performance and licensing issues?
4) Where do I find information on integrating installation (Server & Client) of my SQL database into my application installation CD?
Thanks in advance!