Transfer txt message conversations from Ovi Suite to N9.

[niner]

This is my first post here, so hi all.

I've accidentally deleted all my text messages off of my N9 (yeah I know I feel pretty goofy, just need to read the screen prompts first next time before I hit delete!).

I still have all the messages/conversations in Ovi Suite, however when I sync the phone with Ovi the messages/conversations are not restored back onto the N9 (it seems it's a one way sync from phone to PC).

I've tried dragging and dropping all my conversations in to the inbox (of the N9) in the bottem left corner of Ovi and the messages do transfer back to the N9.

The problem is they're not in 'conversation' form anymore and are just random single messages.

Unfortunately I do not have a recent back up of the N9 to restore from, so how can I get the message conversations from Ovi Suite back onto the N9 in their original 'conversation' format?

Cheers.

[polarbear]

According to this post(http://discussions.europe.nokia.com/t5/Nokia-Suite/Where-does-Ovi-suite-store-SMS-messages/m-p/1204583#M13876) Ovi Suite stores your messages as an sqlite database in "C:\Users\UserName\Appdata\Local\Nokia\Nokia Suite\Messages\Database\msg_db.sqlite" and this TMO post(http://talk.maemo.org/showpost.php?p=1161955&postcount=18) says your on N9 sms should be stored in "/home/user/.cache/tracker/meta.db"

So what should hopefully work is taking that first file, renaming it to meta.db, and replacing that second file on your device. You may need root access(I'm not terribly familiar with the N9). If so, a brief overview of that is here(http://talk.maemo.org/showthread.php?t=79147)

Hopefully this helps. Let me know if it doesn't and I'll try to come up with another solution.

[qwazix]

if the above does not work (possibly the databases have different structure) you could move both .db files to your computer and use sqliteman or other sqlite browser software to copy messages manually.

[polarbear]

Thanks, qwazix, I didn't even consider that. That should hopefully work if the dbs are different. I was assuming that the Ovi Suite just copied the db as is.