How do I view the data in a SqlCE database on a device from visual studio?

Question

I'm debugging an app on a Windows Mobile device and want to view the data in the SqlCE database on the device. I was told to copy the SDF file from the device onto my dev box, but is there an easier way to do it through visual studio without copying anything over?

I'm using Visual Studio 2005, Compact Framework V2 and Windows Mobile 5.

Thanks

Answer 1

In 2008 there is the option of selecting an "ActiveSync connection device" when you add a new connection. This seems to work most of the time although I've had trouble with some devices.

Although I find it's often better to copy the database to the desktop anyway because it's faster to work with.