Database Diagramming Tools for SQL Server CE 4

Question

Although there are GUI tools in VS2010 for entering data, writing queries etc against a SQL CE4 db, there doesn't appear to be a way to visualise the database in a digram.

So my Questions are

A) Have i missed something in VS2010 tools for sql Server CE4

b) Can i use SMSS to Diagram SQL CE4 databases. I've tried it but it wouldn't allow open the db. Is there a plugin available?

Thank you.

Answer 1

Microsoft does not supply a diagramming tool for SQL Server Compact 4, you could try my VS 2010 add-in http://sqlcetoolbox.codeplex.com (Create Database Graph) or the Data Port Console from http://www.primeworks-mobile.com

Answer 2

Actually, there IS a diagramming tool for SQL CE right into VS, but it's hard to find.

I only tried this in VS 2012 Preview, but it might work in older versions - please speak up in the comments.

Here's how to get to it:

In 'server explorer' create a normal connection to the SQL CE database. (No diagramming options are visible...)

Then right-click a table -> "Show table data"... Wait for it...

Hit Ctrl-1.

TA-DA!!

Alternatively, Right-click in the window with the tabular data and choose "Pane" from the context menu. (I know, 'Pane' !?)

Finally, from the 'Pane' submenu click the obvious choice - "Diagram".

There you have it.