'

I want to connect to the ce database  but I'm asked for a password - I never created a specific password for the ce database like you would with sqlexpress.

so, how do I find what the database password is - and, is the password generated automatically by nopcommerce installation the same every time - ie do all sqlce databases created by nop use the same password?

Also,

I've been searching everywhere to find out how I can script out the CE database but it's quite hard to find tools - I would have thought that Microsoft would have had something and certainly thought it would have been possible in sqlmanagement studio as it's possible to connect to the database.

looking at a few tools :

http://www.codeproject.com/Articles/33433/SQL-Server-CE-Query-Tool

http://exportsqlce.codeplex.com/releases/view/80551


anybody have any experience with them - does anyone have advice on upgrading the ce database ?