Aug 20, 2007

SQL CE Management Studio (kind of)

If you've ever tried to use SQL CE databases on your desktop (instead of on your device) and you don't have Visual Studio installed with the mobile developer extensions then you know there's no simple tools for having a look at what's in the database or changing the schema or data in the database.

This is where a tool like SQL CE Console comes in handy. It's a ~A$70 tool from Primeworks that lets you create and edit SQL CE databases on your desktop. It's not the best looking tool in the world but it does it's job well.

Here's a few of it's nice features:

1. Open databases either on the device or on your local desktop

2. View contents of a table (note the statistics at the bottom in the messages window)

3. Run arbitrary queries - note that only the highlighted text was executed in this picture

Overall, I've found this to be a handy little utility and something that I'll slip into my toolbox for future reference.

1 comment:

  1. Hi Richard,
    Thank you for posting about SQL CE Console. This product is about to end its life and will be replaced by Data Port Console, an hopefully nicer are more feature-rich desktop editor for SQL Compact Edition databases. The RC2 version is available for download and I would be very happy to offer you a free license. Please drop me an email on the support address (available on the website).

    João Paulo Figueira