How can I manage SQL CE databases in SQL Server Management Studio?

by

You can create .sdf files with SQL Server 2008 Management Studio.

In the File > Connect Object Explorer dialog,
change the Server Type dropdown to SQL Server Compact Edition.

Then in the Database File dropdown choose New Database…. and you’re ready to go.

More Related Contents:

  1. Is SQL Server Compact discontinued from Visual Studio 2013?
  2. What is the use of GO in SQL Server Management Studio & Transact SQL?
  3. How to connect to local instance of SQL Server 2008 Express
  4. sql server invalid object name – but tables are listed in SSMS tables list
  5. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  6. Query times out when executed from web, but super-fast when executed from SSMS
  7. How do you specify a different port number in SQL Management Studio?
  8. How to find server name of SQL Server Management Studio
  9. Unique constraint on multiple columns
  10. Saving changes after table edit in SQL Server Management Studio
  11. How do I make a composite key with SQL Server Management Studio?
  12. Logging ALL Queries on a SQL Server 2008 Express Database?
  13. How to remove “Server name” items from history of SQL Server Management Studio
  14. Format SQL in SQL Server Management Studio
  15. How to see the values of a table variable at debug time in T-SQL?
  16. How to get export output in “real” CSV format in SQL Server Management Studio?
  17. Can’t get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
  18. How to connect to LocalDb
  19. Using Entity Framework with an SQL Compact Private Installation
  20. Removing the remembered login and password list in SQL Server Management Studio
  21. SQL Server (localdb)\v11.0 explained
  22. How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)
  23. The request failed or the service did not respond in a timely fashion?
  24. Cannot find namespace ‘System.Data.SqlServerCe’
  25. Export stored procedure result set to Excel in SSMS
  26. How to quickly edit values in table in SQL Server Management Studio?
  27. Restrict varchar() column to specific values?
  28. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  29. “If not exists” fails on SQL CE
  30. How to do Sql Server CE table update from another table

Leave a Comment