Can I read a .mdf database created in VS 2010 Express now using VS 2012 Express

Question

0.00/5 (No votes)

See more:

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

Posted 23-Mar-15 8:44am

Member 11525422

Updated 23-Mar-15 9:22am

v2

Add a Solution

Comments

Member 11525422 23-Mar-15 15:24pm

What I have noticed is that in the "new" development database, in particular the Membership and Users table values for Username and UserId differ from the exisiting Web Server Versions.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2015-03-23T12:29:00

Solution 1

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.

Posted 23-Mar-15 12:29pm

Dave Kreskowiak