title: Is there a simple way to copy a SQL Azure Database locally on SQL Server 2014?
body: <p>I have created a bacpac file through the <strong>Export</strong> option of Azure.</p>
  
  <p>Then, I tried to import the bacpac file into SQL Server installed locally on my pc, selecting in SQL Server Management Studio, the “<strong>Import Data-tier Application…</strong>” feature.</p>
  
  <p>The import fails becouse the destination version of sql server is not the same of the source (namely from Sql Azure to SQL Server 2014).
  I have in fact locally installed on my pc SQL Server 2014.</p>
  
  <p>To fix the problem I should create a  new SQL Server database project in <strong>Visual Studio 2017</strong>,  remove some incompatibilities like the following:</p>
  
  <pre><code>--CREATE DATABASE SCOPED CREDENTIAL
  --    WITH IDENTITY = N'SHARED ACCESS SIGNATURE';
  </code></pre>
  
  <p>Then I should publish the project to create a new db locally.</p>
  
  <p>But the new db obtained publishing the Visual Studio Project is empty and so I have to manually copy the data, cause the <strong>Import Data</strong> function in SSMS doesn’t work because of some problems like column identity.</p>
  
  <p>Is there a quick and simple way of creating a local copy of a SQL Azure Database on my local SQL Server?</p>
  
  <p>Thanks</p>