After some research on net I found few limitations of Microsoft new Embedded database i.e. SQL Server Compact 4.0 the findings are given bellow.
According to Scott Guthrie “Max size”
“It currently supports databases up to 4GB in size - although we are looking to hopefully increase that. It supports foreign keys. It does not supports sprocs or triggers.”
According to books online
SQL Server Compact 3.5 SP2 is the appropriate version for using the following features.
Data replication with SQL Server
SQL Server Compact 4.0 does not support data replication with SQL Server using Sync Framework, merge replication or remote data access (RDA). In order to use this feature, you should use SQL Server Compact 3.5 SP2 version.
SQL Server Integration Services
SQL Server Compact 4.0 does not support SQL Server Integration Services (SSIS). In order us this feature you should use SQL Server Compact 3.5 SP2.
SQL Server Management Studio
Starting from SQL Server Compact 4.0, SQL Server Compact does not support SQL Server Management Studio. The Transact-SQL Editor in the Visual Studio 2010 Service Pack 1 can be used to run T-SQL queries and to view the estimated and the actual query plans for a T-SQL query for the SQL Server Compact database.
LINQ to SQL
SQL Server Compact 4.0 does not support the LINQ to SQL functionality. You can use this feature in SQL Server Compact 3.5 SP2. For more information, see LINQ to SQL (SQL Server Compact).
Windows Mobile, Windows Phone and Windows CE devices
SQL Server Compact 4.0 does not have a release for Windows Mobile, Windows Phone or for Windows CE devices.
Looking at documentation I also found this “SSCE_M_RECORDTOOBIG” error token is raised when “The table definition or the row size exceeds the maximum row size of 8060 bytes” that means a row can have max 8k of data, sounds stupid.
Its has support of “Number of concurrent connections” unto 256.
I still need to know few information's, and looking forward to get those information in near future.
- What are the max number of column in a table?
- What are the max number of row in a table?
- What are the max number of table in database?
If any one know this information please share.