将 SQL Server Express 2005 .mdf 转换为 2008 .mdf？
您好，我有一个 Visual Studio 解决方案和一个 ASP.NET MVC 项目，该项目在 App_Data 中使用 SQL Server Express 2005 数据库文件。我想知道如何升级此文件，使其适用于 SQL Server Express 2008？
谢谢
Hi I have a Visual Studio solution and an ASP.NET MVC project that uses a SQL Server Express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for SQL Server Express 2008 ?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您可以在 SQL Management Studio 2008 中发出 Attach 命令。它将使用 .mdf 的路径命名数据库，但使用它没有问题。
数据库将采用 2005 兼容模式，但您当然可以根据需要自行更改。
You can issue the Attach command in SQL Management Studio 2008. It will name the database with the path to the .mdf, but it'll use it no problem.
The database will be in 2005 compatibility mode, but you can certainly change that yourself as you see fit.
您所要做的就是创建 2005 数据库的备份 (.bak)，然后将其恢复到 2008 Express 服务器上。就是这么简单。
如果您想在文件级别处理它，只需从 2005 分离并附加到 2008。如果它是在 AppData 中创建的解决方案，您只需将其移至较新的项目即可。
All you have to do is create a backup (.bak) of your 2005 db and then restore it on your 2008 Express server. It's that simple.
If you want to deal with it on the file level, simply detach from 2005 and attach to 2008. If it's solution-created in your AppData all you should have to do is move it to the newer project.
替代文本 http://img714.imageshack.us/img714/4514/sqlserver.jpg< /a>
看起来这个数据库实际上是 2008 年的兼容性级别，所以我认为我没问题。我弄清楚了如何在 SQL Server Management Studio 中附加文件，但感谢您提到兼容性模式。
我尝试制作备份，然后使用备份文件作为数据库恢复它，它在与原始文件相同的文件夹中创建了一个新的 mdf 文件，这正是我想要的，但不太清楚它会这样做。谢谢
alt text http://img714.imageshack.us/img714/4514/sqlserver.jpg
Looks like this database is actually 2008 from what that compatibility level says so I think I am ok. I figured out how to attach the file in SQL Server management studio but thanks for mentioning about the compatibility mode.
I tried out making a backup and then restoring it using the backup file as a database and it made a new mdf file in the same folder as the original which is what I wanted, wasnt very clear that it was going to do that. Thanks