SqlExpress mdf数据库不兼容 [英] SqlExpress mdf DB incompatibility

问题描述

我在一个站点中使用了ASP.NET(.NET4)默认ASPNETDB.mdf数据库，该数据库是在使用成员身份时创建的.然后，我将该站点复制到Web服务器.现在它已经运行了一段时间，因此有内容和评论.但是我现在需要对代码进行更改，这也需要在数据库中添加额外的字段，因此我将.mdf从服务器复制到了本地计算机上，以编辑和添加字段(这样我就不会丢失内容等).但是当我在替换mdf后运行项目时，出现以下错误:

"The database ".....APP_DATA\ASPNETDB.MDF" cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Cannot open user default database. Login failed. Login failed for user ''Me-PC\Me''.

这使我感到困惑，因为它是我的家庭VS生成的确切的mdf文件.该服务器也运行与我相同的.NET，所以我不明白为什么它会更改任何内容.

I used the ASP.NET (.NET4) default ASPNETDB.mdf database that gets created when using membership, in one of my sites. I then copied the site to the web server. Now it has been running for a while so there is content and comments. But I now need to make changes to the code that will also require extra fields in the db, so I copied the .mdf from the server to my local machine to edit and add the fields(so I didnt lose content etc). But when I run the project after replacing the mdf i get the following error:

"The database ".....APP_DATA\ASPNETDB.MDF" cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Cannot open user default database. Login failed. Login failed for user ''Me-PC\Me''.

This confuses me, as it is the exact mdf file that my home VS generated. The server is running the same .NET as I am too, so I dont see why it would have changed anything.

Thanks!

推荐答案

您是否正在使用VS2010的Express版本?

我的Express版本也有同样的问题.当然，它也可能会影响整个游戏，但由于我没有，所以我无法确认.

在我的情况下，原因是我已将SQLServer2008 Express升级到SQLServer2008 Express R2.

你做完了吗?

当我安装MS LightSwitch时，我的问题已解决，但因为这还会安装升级到EF 4.0，SilverLight等的负载，等等.我无法指出实际的解决方法.

如果没有人为您提供确定的解决方案，我建议您在MS支持论坛上提出.

Are you using the Express version of VS2010?

I had the same problem with my Express version. Of course it may also affect the full one too but as I don''t have it I can''t confirm this.

The cause in my case is that I had upgraded SQLServer2008 Express to SQLServer2008 Express R2.

Have you done that?

My problem was resolved when I installed MS LightSwitch but as this also installs loads of upgrades to EF 4.0, SilverLight etc. etc. etc. I cannot pin point the actual cure.

If no-one comes up with a definitive solution for you I would suggest that you raise this on the MS Support Forums.

我会 不 如果您是我，请安装LightSwitch.在我这样做之后，我的VS2008 Pro和VS2010 Express安装变得不稳定，现在掉下来就掉下来了，而以前它们是坚如磐石.

安装后，所有我的数据库文件都可用.

首先尝试MS论坛.只能将LightSwitch用作最后的手段.

I would not install LightSwitch, if I were you. After I did so my VS2008 Pro and VS2010 Express installations became flaky, they now fall over at the drop of a hat whereas before, they were rock solid.

After the install all my DB files were available.

Try MS Forums first. Only use LightSwitch as a last resort.

这篇关于SqlExpress mdf数据库不兼容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！