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();
            }

转载于:https://www.cnblogs.com/yestech/p/6038638.html