title: Copy SQL Azure Database to different Server
body: <p>SQL Azure database supports copying whole database asynchronously with a single command as below:</p>
  
  <p>I have  been using to copy database within same server using</p>
  
  <pre><code>CREATE DATABASE [targetdb] AS COPY OF [sourcedb]
  </code></pre>
  
  <p>But when I try to copy database to a different SQL Azure server:</p>
  
  <pre><code>CREATE DATABASE [targetdb] AS COPY OF [source_sql_azure_server].[sourcedb]
  </code></pre>
  
  <p>But I get below error:</p>
  
  <p>Cannot open server "source_sql_azure_server" requested by the login. The login failed.</p>
  
  <p>How do I copy?</p>