Increase the size of sql compact 3.5 .sdf file

c# sql-server-ce filesize
Jankhana picture Jankhana · Mar 9, 2010 · Viewed 22.9k times · Source

I'm using Sql Compact3.5 as my DB with C# .NET what is the maximum size of sdf that I can give? Is there any way to programatically increase the maximum size of the sdf file? If so how?

Answer

Benny Jobigan picture Benny Jobigan · Mar 9, 2010

The maximum size of the database is by default 128 MB. Override this by using the following connection string.

Data Source=MyData.sdf;Max Database Size=256;Persist Security Info=False;

(from: http://www.connectionstrings.com/sql-server-2005-ce) and (from: http://msdn.microsoft.com/...)

The absolute maximum size of the database is 4gb.

Related questions

Connection string with relative path to the database file

I load data from sdf database in winforms App. I use full path to the database file . Example : conn = new SqlCeConnection { ConnectionString ="Data Source=F:\\My Documents\\Project1\\bin\\Debug\\Database.sdf" }; I d like use a relative path to …

Read More
how to open *.sdf files?

I used to open sdf (sqlCE) files with visual-studio? or sql-server? I really don't remember. Now I can't open this sdf file. With what program do I need to open it?

Read More
How to change column width in DataGridView?

I have created a database and table using Visual Studio's SQL Server Compact 3.5 with a dataset as my datasource. On my WinForm I have a DataGridView with 3 columns. However, I have been unable to figure out how to get the …

Read More