is there a table cap for MS SQL Compact Edition? [modified]
-
Hi everyone I developed a software but somehow (by mistake to be honest) in the beginning I used MS SQL Compact Edition the system works fine, but I know that compact edition is very limited than Sql Server 2005 According to my algorithm, every entered record creates several tables. This works good. But I'm a bit nervous about latter stages Does this Compact Edition has a table cap? for example, after 5000. table created, does the DB gives an error like "DB table quantity limit reached" or sth like that? I know it sounds ridicilous but I've encountered numerous ridicilous errors since I started this project
modified on Monday, November 16, 2009 8:00 AM
-
Hi everyone I developed a software but somehow (by mistake to be honest) in the beginning I used MS SQL Compact Edition the system works fine, but I know that compact edition is very limited than Sql Server 2005 According to my algorithm, every entered record creates several tables. This works good. But I'm a bit nervous about latter stages Does this Compact Edition has a table cap? for example, after 5000. table created, does the DB gives an error like "DB table quantity limit reached" or sth like that? I know it sounds ridicilous but I've encountered numerous ridicilous errors since I started this project
modified on Monday, November 16, 2009 8:00 AM
http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx[^] There is the link with a doc file, where you can read all difference between Compact and Express Edition. For what I saw the only major limitation is 4GB of database