CODEWITHSUNDEEP
sql-server-cessms
Benjamin
Benjamin

Reputation: 896

SQL Server CE Database: SSMS Remembers My Password, But I Don't -- Next Steps?

Good morning all,

I created a database in SQL Server Compact Edition using SQL Server Management Studio. When I started, I created a password and had SSMS remember it for me. However, I'm reaching the point when I pass the database on to others... and it suddenly hit me: I forgot my password.

Does anybody know what recourse I may have in this situation? Is there a way to recover the password, or to replicate the database (from within SSMS) to a new, password-free copy? I suppose as an absolute last resort -- the project is reasonably small, only a couple dozen tables -- I could export everything to text files and re-create it from scratch. Is there functionality within SSMS/SQLCE, or are there third-party tools, to make that task a little easier?

Thank you very much for your time and advice.

Benjamin

Upvotes: 0

Views: 1048

Answers (1)

ErikEJ
ErikEJ

Reputation: 41819

You can install my SSMS add-in which allows you to export the entire database to a script file, that you can then run against a new database - http://exportsqlce.codeplex.com/

Upvotes: 1

Related Questions