how to upgrade the android app version one Own SQLite Database without loosing the existing data
<p>I need to update my android application in the market to next version.next version i need to update the sqlite DB without loosing the exsiting data.</p>

<p>In version one i did not create the tables in runtime instead get the database file from the "assets" folder and copies into the system database path of my application.
Refer to this link 
<a href="http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/" rel="nofollow">http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/</a></p>

<p>next version of my app i have modify the exsting table columns and add extra records and there are few new tables as well.I have updated the data base and copied to asset folder. </p>

<p>This will work for users who buy the app for first time,but not for existing users,my question is how can i update the version one users data base without loosing existing data</p>

<p>Sam.</p>
