If you're like me and you have upgraded to SqlServer 2008 and no longer have SqlServer 2005 installed, you can open your SqlCe database by using the following simple code:
try
{
SqlCeEngine eng = new SqlCeEngine(@"DataSource=C:\MyDataBase.sdf");
eng.Upgrade(@"DataSource=C:\MyDataBaseNew.sdf");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
It only takes a second and then the new database can be opened, edited, and viewed in 2008.
