You are currently offline, waiting for your internet to reconnect

How to Uninstall SQL Compact 3.5 after installing SQL Server 2008

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Summary
SQL Server Compact 3.5 SP1 can be installed using one of the following methods:
  • As part of SQL Server 2008 installation.
  • As part of installing Visual Studio 2008 or later versions.
  • Downloading it from the Microsoft downloads site.

For further information refer to Installing SQL Server Compact topic in SQL Server 2008 Books Online.

This article describes how to uninstall SQL Server Compact 3.5 SP1 from a machine where the SQL Server Compact functionality is not needed.

More Information

There are two SQL Server Compact related components that gets installed by SQL Server 2008:

  • Microsoft SQL Server Compact runtime (SSCERuntime.msi)
  • Microsoft SQL Server Compact Query tools (SSCESqlWbTools.msi)

You can uninstall both these components using either of the following methods.

  • Use Control Panel’s Add or Remove Programs applet or Programs and Features (in Windows Vista and Windows 7) to remove these programs.
  • Since SQL Server Compact’ MSIs are based on Windows Installer technology you can also use the Msiexec from command line to uninstall these components.

For example, the following command line will uninstall SQL Compact runtime .msi :

 msiexec /x   ssceruntime_enu.msi

You can run msiexec /?   on a command line to see the complete list of options. 

Note: After you uninstall these SQL Server Compact components, you will no longer be able to interact with SQL Server Compact databases from SQL Server Management Studio on that system.

Additional references:  
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2015126 - Last Review: 02/15/2010 21:27:00 - Revision: 2.0

Microsoft SQL Server Compact 3.5

  • KB2015126
Feedback
ync=""> var varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ng" id="language-es-py">Paraguay - Español
Venezuela - Español
/html>did=1&t=">amp;did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" ';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">