title: Deploy database to Azure SQL fails, sp_MSforeachtable not found
body: <p>I am trying to publish a SQL Server database using a <code>.dacpac</code> and publish profile to an Azure SQL database. We have been using on premises SQL Server with no problems for quite some time, and now we are evaluating Azure and AWS to see which is best suited for our needs. </p>
  
  <p>We have a SQL Server database project and want to deploy it to Azure SQL  database, however it fails to execute the script generated by SSDT. This is because the generated script contains a call to the stored procedure <code>sp_MSforeachtable</code> which does not exist in Azure SQL. </p>
  
  <p>I also have changed the target platform from SQL Server 2016 to Azure SQL V12. I am trying this from Visual Studio 2017's publish profile and from VSTS Release management using Azure SQL database deployment task. An of course by providing the necessary <code>.dacpac</code> and <code>publish.xml</code> files in the task.</p>
  
  <p>I know I can manually add the stored procedure, however it doesn't seem that is what is intended by these publishing/deployment methods. Does anyone have any ideas?</p>
  
  <p>Thanks</p>