Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mathmax
Yak Posting Veteran
95 Posts |
 Posted - 2007-08-19 : 20:56:21
|
| Hello,I wonder which differences there are between Sql Server and Sql Server Compact Edition. In which case to use Compact Edition rather than Normal Edition ?For example, which version is it preferable to use for a database which is just use to persist some informations of a single program ?Thanks,mathmax |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-19 : 22:55:37
|
| Compact Edition (previously Mobile Edition) is a compact database for embedding in mobile and desktop applications. I prefer express for desktop since it has more features. Standard and enterprise editions are better but they are not free. |
 |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2007-08-23 : 11:14:43
|
| Check out http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx for a paper we wrote to help people decide which engine to use. They are both great choices for desktop applications, but which one you need depends upon your specific solution.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
|
|
Difference between .mdf and .sdf file.