我现在可以使用VS 2012 Express读取在VS 2010 Express中创建的.mdf数据库吗？ [英] Can I read a .mdf database created in VS 2010 Express now using VS 2012 Express

问题描述

嗨和TIA：



我有一系列的aspx页面，可以在Web服务器上读取/更新等2010开发的数据库，而且一切都很顺利版本。



我已经使用VS 2012 Express更新了我的开发机器上的页面，再一次在本地都很好，因此我觉得是时候上传我的2012年新页面。但是，我没有上传新的数据库表，包括会员和用户。



我有一个登录页面，当我现在尝试使用用户名和密码登录时在2010版本中工作，我得到错误用户登录失败。



我的问题是我必须做些什么来获取新旧页面访问旧数据库并能够登录。我是否需要在我的开发机器上重新创建旧的（在Web服务器上）表，然后重新上传（这似乎很多工作，但是如果这是我必须做的那就没关系）？



任何想法都会有所帮助。

谢谢，Cliff

解决方案

首先，Visual Studio没有没有数据库引擎。安装将安装Sql Server Express版本，或者在新版本中安装SQL Server LocalDb。



因此，您是否可以使用在旧版SQL Server Express中创建的MDF文件更新的？是

Hi and TIA:

I have a current series of aspx pages that reads/updates etc a 2010 developed database on a Web Server and all is well with that version.

I have since "updated" the pages on my development machine using VS 2012 Express and once again all is well locally, thus I felt it was time to upload my new 2012 pages. I did, however, NOT upload the new database tables including Membership and Users.

I have a login page and when I now try to login with a username and password that worked in the 2010 version, I get and Error "Login failed for user".

My question is what must I do to gain access with my new pages to the old database and be able to login. Do I need to re-create the old (on web server) tables on my development machine and then re-upload (which seems like a lot of work, but it's Ok if that is what I must do)?

Any thoughts would be helpful.
Thanks, Cliff

解决方案

First, Visual Studio doesn't have a database engine. The installation installs Sql Server Express edition or, in new editions, SQL Server LocalDb.

So, can you use a MDF file created in an older SQL Server Express in a newer one? Yes.

这篇关于我现在可以使用VS 2012 Express读取在VS 2010 Express中创建的.mdf数据库吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！