Monthly Archives: April 2014

First off some back story for this post. My niece bought a Samsung galaxy S4. She used it for about a month, then decided to go back to her iPhone and give the Samsung to her brother. This meant that as a programmer, I had to find some way to transfer her android messages to her iPhone.

My basic plan is:

  1. backup iPhone via iTunes
  2. backup android SMSs via SMS Backup and Restore
  3. transfer android SMSs into the iPhone backup using sqlite.
  4. restore iPhone from altered backup

So first off I have to take a look at the sms database. It can be found in your iTunes backup folder (for me it was %APPDATA%/Apple Computer/mobile sync/backup/). there’s one more folder with all the backups, the one you are looking for is named “3d0d7e5fb2ce288813306e4d4636395e047a3d28”.

Here are the tables inside:

[Show Tables]

First lets look at how they all relate:

Just from making up this chart of how the tables relate, I have already seen areas where I made mistakes when I first tried to inject messages into the database. If you don’t understand the lines joining each table, here is a quick refernce sheet: http://www.vivekmchawla.com/2013/04/erd-crows-foot-relationship-symbols-quick-reference.html

So a message is made up of: the body of the message (message), an address (handle), a conversation (chat), and sometimes an attachment (attachment).

Lets look at the tables:

[Show Message Table]

[Show Handle Table]

[Show Chat Table]

That’s it for now. I’ll continue this blog post another time, though I hope you have found this helpful so far.

Edit. I spent about 2 hours creating custom shortcodes for wordpress to implement those [Show/Hide] tags. I’ll finish this another day.

I have moved to Perth! I decided I needed to advance my career, and there was no chance of that happening back home in Cairns, where there are almost no jobs in IT available, so I decided moving to the city would be my best option. I first considered Brisbane, because it was much closer to home, but after a while I realized I would pretty much have to start from scratch and find a place to live straight away. Because of this, I decided Perth was the best option as I have my sister and her family that I can stay with while I find my feet. I came over for a holiday in May and bought a brand new car, (my own car would most likely not make the trip across Australia) and got a transfer with Woolworths to the local store, so I had a job to come to. Then 3 weeks after my holiday, I flew over with 50kgs of my possessions and started life in the big city.