title: How to migrate changes in SQLite file into an existing app?
body: <p>I've submitted an iOS app with <code>SQLite</code> database file to store data inside the app. </p>
  
  <p>Now in next version of the app – I have some modifications in a database file.</p>
  
  <p>Like,</p>
  
  <ol>
  <li>Added new tables (1 empty, 2 with fixed data)</li>
  <li>Added new columns in a table</li>
  <li>Removed existing columns from a table</li>
  </ol>
  
  <p>What, I thinking?</p>
  
  <blockquote>
    <p>I'll add a new database file (which included all changes) in my app, at first run of the app (after update) I'll check for the existence of an old database file, if available, will append everything from old to new file and lastly will delete the old file.</p>
  </blockquote>
  
  <p>Is this the right way or there can be a more significant way like Core Data migration Or other more appropriate way?</p>