How to move your data from CPT Lite to CPT Pro (using iTunes)

If you just upgraded from CPT Lite to CPT Pro, the first thing you’re going to want to do is migrate your data from CPT Lite to the CPT Pro database. One way to do this is to use the Apple iTunes File Sharing capabilities. Here are the steps…

Before you begin, make sure you have loaded the CPT Pro version onto your device. Don’t worry, it won’t affect the CPT Lite app that is already on the device. The iPhone considers them two separate applications, so they won’t interfere with one another.

  1. We are going to be copying the CPT Lite database into the CPT Pro app space using iTunes File Sharing feature. So, begin by connecting your device to the Mac/PC and starting up iTunes. Once you see the device icon in the upper left menu bar, click on it. You should now see the device’s Settings menu along the left side of the screen, and the device Summary in the main area of the screen.


  2. In the menu on the left side of the screen, click on the “Apps” item. This is where you can manage your device’s app content.
  3. Scroll down to the File Sharing section of the screen.
  4. The File Sharing section consists of a scrollable table where apps that support File Sharing will be listed and a window on the right showing the files each app contains. You should see both Pain Tracker (CPT Pro) and Pain Tracker Lite (CPT Lite) listed in the table. Start by selecting Pain Tracker Lite.
  5. The key file we need to move to CPT Pro is the database file named “CPT_PrimaryDiary.sqlite”. Select this file from the list and click on the “Save to..” button. In the file browser that comes up, select a location on your Mac/PC to save the database file.


  6. Now, select the “Pain Tracker” app from the table on the left. You’ll then see the files contained in the CPT Pro app. You’ll probably already see the same “CPT_PrimaryDiary.sqlite” file listed here as well. This is the file we are going to replace with the one from your CPT Lite app.
  7. Click on the “Add..” button and select the “CPT_PrimaryDiary.sqlite” file from your Mac/PC. iTunes will then overwrite the existing CPT Pro database with the one from CPT Lite.


That’s it! Now disconnect your device from iTunes and start CPT Pro to verify that the database has indeed been migrated.