What is Microsoft SQL Server 2005 Compact Edition ENU and do I need it?

Question

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop as well as on mobile devices.

Do I need Microsoft SQL Server on my computer?

And, yes, you need SQL Server to have any use for SSMS. SSMS is just a tool to talk to SQL Server. As for what SQL Server does - it does the same as MySQL: it is a relational database management system, RDBMS. Beware, though, that SQL Server and MySQL do not always do things in the same way.

Is it safe to uninstall Microsoft SQL Server 2005 Compact Edition?

You can go ahead and uninstall the Microsoft SQL Server 2005/2008. This will not effect the functioning of other Office applications.

What is SQL Server Compact used for?

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications.

Why SQL Server is needed?

The core component of Microsoft SQL Server is the SQL Server Database Engine, which controls data storage, processing and security. It includes a relational engine that processes commands and queries and a storage engine that manages database files, tables, pages, indexes, data buffers and transactions.

Expert · Answer