Browse and edit data in Microsoft SQL CE databases

I’ve been working on a little project that requires Microsoft SQL CE databases and couldn’t find anything that did quite what I wanted. SQL Server Management Studio allows for design of CE databases but not for browsing/editing data easily.

Sql CE Browser v1.1, updated (download now for free, 2,283 KB) allows you to browse and edit data in SQL CE databases.

Features:

  • Open regular and encrypted/passworded databases for viewing or editing
  • Write and work with any number of queries at once via tabs
  • SQL syntax highlighting and SQL syntax verification
  • Explore columns, keys, and indexes
Sql CE Browser main window

Sql CE Browser main window

Sql CE Browser table properties

Sql CE Browser table properties

December 9th, 2009 by Eric Willis
Tags: , , , ,
Posted in software | 2 Comments »


2 Responses to “Browse and edit data in Microsoft SQL CE databases”

  1. ErikEJ says:
    December 10, 2009 at 5:54 am

    Nice tool – I have created a SSMS(X) 2008 add-in, that adds the following missing features:
    - Browse/Edit data
    - Script tables
    - Script data
    - Import CSV
    available here: http://exportsqlce.codeplex.com/

  2. Eric Willis says:
    December 17, 2009 at 12:31 am

    Erik, that’s pretty cool and it’s a SSMS plugin too! I’ll definitely have to check it out.



Recently


More