title: What is the correct way to copy data from a postgresql database in one app to a postgresql database in another app on heroku?
body: <p>I have been following the documentation <a href="https://devcenter.heroku.com/articles/heroku-postgres-backups#restoring-backups" rel="noreferrer">Heroku docs on the subject</a>
  and have gone through this and tried variations on what it says to do to for </p>
  
  <blockquote>
    <p>Direct database-to-database copies</p>
  </blockquote>
  
  <p>I am convinced the docs are wrong or I have some setting or somthing wrong (do have admin access). I have also read some scattered things on SO that the command in the heroku CLI for how to do this has changed. </p>
  
  <p>When I run this command (using the credentials for my heroku DB) </p>
  
  <pre><code>heroku pg:copy sushi::ORANGE GREEN --app sushi-staging
  </code></pre>
  
  <p>After I confirm the message:</p>
  
  <blockquote>
    <p>WARNING: Destructive action
     ▸    This command will remove all data from</p>
  </blockquote>
  
  <p>and confirm. Then I get an error that says:</p>
  
  <blockquote>
    <p>Heroku PostgreSQL database must be source or target</p>
  </blockquote>
  
  <p>What is the corrrect way to copy data from a postgresql database in one app to a postgresql database in another app on heroku?</p>