I need a free database with my .NET desktop application. It must be shipped to the final user along with the application when the application is installed without any additional hassle or any additional installation procedures by the user.
I use Visual Studio 2010 and saw SQL Server Compact 3.5 database can be shipped for free. The application will retrieve data from a remote server every day so the database will become larger over time. I'm concerned with the 4GB limit the SQL Server Compact 3.5 has. The data is only plain tables (no relational data), but the amount of rows is huge and grows constantly.
Is there a way to forecast if 4GB is enough for my purpose?
Is there any other alternative free database that I could use instead of SQL Server Compact?
I use Visual Studio 2010 and saw SQL Server Compact 3.5 database can be shipped for free. The application will retrieve data from a remote server every day so the database will become larger over time. I'm concerned with the 4GB limit the SQL Server Compact 3.5 has. The data is only plain tables (no relational data), but the amount of rows is huge and grows constantly.
Is there a way to forecast if 4GB is enough for my purpose?
Is there any other alternative free database that I could use instead of SQL Server Compact?