title: android application with two database
body: <p>Am making an app, which contains a database in the assets folder, say the database as db1. When I open the app, am again creating a db using the <strong>API'S</strong>. Both the db names are similar. </p>
  
  <p>When copying the db I see that the db1 created using api`s is getting over written by db1 in assets. Here I have a solution that first to copy the db from assets then followed by open the same in java.
  In assets folder db it contains tables namely <strong>A</strong>,<strong>B</strong>,<strong>C</strong> and the db created using code am making tables <strong>A</strong>,<strong>B</strong>,<strong>C</strong>,<strong>D</strong>,<strong>E</strong>,<strong>F</strong>.</p>
  
  <p>Now what I want is:</p>
  
  <p>When I give an upgrade for the app, I cannot blindly copy the database in the assets will overwrite all the existing data in the <strong>db1</strong>( All tables ). I want to know can I copy the database with some other name say <strong>db2</strong>. Then open and copy all the tables in <strong>db2</strong> and overwrite those tables in <strong>db1</strong> with the newly copied tables; i,e tables <strong>A</strong>,<strong>B</strong>,<strong>C</strong> tables in <strong>db1</strong> has to be replaced with with the tables in <strong>db2</strong>.</p>
  
  <p>I want know if it is possible or not? If possible some give me some samples are references. </p>