SqlCeEngine.Upgrade
在.net中使用:
SqlCeConnection conn = new SqlCeConnection("Data Source = D:\\db\\wt.sdf; Password ='ddfo'");
conn.Open();
会出现下面异常信息:
The database file has been created by an earlier version of SQL Server Compact. Please upgrade using sqlCeEngine.Upgrade() method.
解决方法已经在错误信息中给出来了,用 sqlCeEngine.Upgrade() 方法:
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection("Data Source = ********"); // 此处填写密码。
try
{
conn.Open();
}
catch
{
try
{
string newPathToDatabase = @"Data Source = ********";
SqlCeEngine sqlCeEngine = new SqlCeEngine(newPathToDatabase);
sqlCeEngine.Upgrade(newPathToDatabase);
conn = new SqlCeConnection(newPathToDatabase);
conn.Open();
}
catch (Exception ex) { }
}
}
finally
{
conn.Close();
}