title: Copy one database to another database
body: <p>How to copy from one database to another database.</p>
  
  <p>Database name visco</p>
  
  <p>I want to copy all the table from visco database to new database name as neptune</p>
  
  <p>I was created one database with out any tables, then i try to restore the database from database1.bak file, then it is showing error as </p>
  
  <pre><code>You are attempting to overwrite an existing database.  Check the force restore over existing database option to 
  overwrite the existing database.
  </code></pre>
  
  <p>Need Query Help</p>