
Microsoft Sql Server Compact Edition 3.5 Sp2 Software Program Developed
I have a few basic questions on SQL Compact - and hope I can get some clarification.How can i create one MSI that will handle both cases Hmmm.I wonder why, if that were possible, why Microsoft has 2 separate packages for their apps Youll.Microsoft SQL Server Compact 4.0 ENU is a software program developed by Microsoft. Support for the Transact-SQL Editor in Visual Studio 2010 that can be used to run free-text T-SQL queries and to view query show-plans for optimizing queries and. SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. Microsoft SQL Server Compact SP2 ENU.
...

The 4GB size limitation means a SQL Server Compact database can't exceed 4GB. It seems there is no question 3. However, I would suggest you updating the SQL Server Compact Edition to 3.5 SP2.3.
Microsoft SQL Server Compact Edition is the rebranding of Microsoft SQL Server Mobile without the desktop restriction.If there is anything unclear, please feel free to ask. We can use SQL Server Management Studio(SSMS) to connect to a SQL Server Compact database.7. This means there is not remote access for the SQL Server Compact.6. We connect to the SQL Server Compact through the database file directly. In order to go larger than 4GB, please create more than one database.5.
