title: VS2013 - How do I connect to local .mdf with SQL Server Management Studio?
body: <p>I'm starting a new project and intend to use a local database file during development, rather than using a network server.  I can query it by right clicking on the .mdf in Server Explorer and selecting New Query, but that's going to be a pain in the neck to have to copy all of my sql scripts over to it on a regular basis.</p>
  
  <p>I apologize if my post is ambiguous - I'm having a hard time wording what I want to do.  I want to use the SQL Server prompt with the .mdf file in my App_Data. <a href="http://i.imgur.com/6WAjg0Y.png" rel="nofollow">(screenshot)</a></p>
  
  <p>When I check the connection string of the <code>.mdf</code> in Server Explorer, I get the following:</p>
  
  <pre><code>Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\[username]\Desktop\...\App_Data\localdb.mdf;Integrated Security=True
  </code></pre>
  
  <p>I've not managed to get this string, in any form, to work, though.</p>