staritsj
asked on
Best Back End Database Solution
Hi. I am looking for some advice in terms of the best and most cost effective back end database for a commercial vb 2005 winforms application. The application will reside on the clients windows server and have a maximum of 20 users/connections. I am currently considering things like MySQL or SQL Server Express Edition. Initally the number of transactions and table records will be relatively low however this will grow over time. Can any advice also please detail licensing requirements and est. costs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Express is FREE. It's MSSQL compatible, and should handle 20 user connections fine. It has a database size limit of 4 GB, If I'm not mistaken (AT LEAST 2 GB). So provided the database stays relatively small, it's more than sufficient for these purposes. If the database/user base grows, you can just upgrade to MSSQL. In smaller environments, your clients can use SBS to gget full SQL server support at a reasonable price.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.