Reputation: 21
I've decided to develop VB.net Application With SQL server Express 2008, but Microsoft says:
They limit 4 GB Size per DB!
So I'm developing my app for Single user Desktop pc, so what should I do when the DB reached the Maximum size?
When the DB size reached to maximum size, is it a good thing to create a new DB and allow my vb.net application to work with both DBs?
Upvotes: 0
Views: 1570
Reputation: 13157
If you expect to exceed 4GB (are you sure?) then some options might include...
Upvotes: 0
Reputation: 1809
Nothing wrong to attempt for free tools. I suggest that you redesign your application to use multiple databases.
1) Create a new table for storing multiple databases setting data
2) Things to store in that table include: total databases, connection string for each database, and so on.
Consider storing each table in a separate database (where appropriate)
Upvotes: 1
Reputation: 6532
SQL Server 2008 R2 Express size limit was increased to 10 GB, so if your just starting a new project you should use 2008 R2.
Upvotes: 2
Reputation: 103579
in regards to the 4GB limit of your free version of SQL Server, your options as I see them:
1) purge old data as it becomes unnecessary
2) hack application to use multiple databases (would this even work on a single pc?)
3) hack your application to move items to data files as necessary and out of the DB
4) pay for the proper version of SQL Server
5) go to MySql or something similar
Upvotes: 3