title: .NET move database from App_Data to SQL Server
body: <p>I think I've figured out how to post my data to SQL Azure using DMA, but first I need to get it onto a server connection.</p>
  
  <p>How do I get my database from my app data folder onto a SQL Server?</p>
  
  <p>I've been following <a href="https://docs.microsoft.com/en-us/aspnet/web-forms/overview/older-versions-getting-started/deployment-to-a-hosting-provider/deployment-to-a-hosting-provider-migrating-to-sql-server-10-of-12" rel="nofollow noreferrer">this guide</a> but doesn't really explain it:</p>
  
  <p>I currently access my data through:</p>
  
  <pre><code>using System.Data;
  using System.Data.Entity;
  </code></pre>
  
  <p>and this is my connection string:</p>
  
  <pre><code>&lt;add name="DefaultConnection" 
       connectionString="Data Source=|DataDirectory|Linkofy-Release.sdf" 
       providerName="System.Data.SqlServerCe.4.0" /&gt;
  </code></pre>