Page 1 of 2 12 LastLast
Results 1 to 10 of 14
Discuss Merge two SQLite files into one (sms from two phones on new phone) at the General - Hackint0sh.org; hi i've had my 1.1.4 phone for long time, used many SMS. then when 2.0 ...
  1. #1
    Senior Professional Array

    Join Date
    Aug 2007
    Posts
    300
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    24

    Default Merge two SQLite files into one (sms from two phones on new phone)

    hi

    i've had my 1.1.4 phone for long time, used many SMS.
    then when 2.0 came out, i istalled 2.0 on another phone and intended to use it only a week or so, and did not load a backup from the 1.1.4 phone.
    well, i used it for long time now, and now i'm having a SMS Sqlite file from the old phone, and one from the new phone.

    is there a way to merge these to SQLite files together? no matter if its windows or OS X solution, i have both.

    tanks



  2. #2
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by fabiopigi View Post
    hi

    i've had my 1.1.4 phone for long time, used many SMS.
    then when 2.0 came out, i istalled 2.0 on another phone and intended to use it only a week or so, and did not load a backup from the 1.1.4 phone.
    well, i used it for long time now, and now i'm having a SMS Sqlite file from the old phone, and one from the new phone.

    is there a way to merge these to SQLite files together? no matter if its windows or OS X solution, i have both.

    tanks
    I am using the Firefox Plugin SQLite Manager. It is free and for Mac/Win. You have to know what to do with sql statements, but this is the way to go for.

    Check for add-ons in Firefox
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2

  3. #3
    Senior Professional Array

    Join Date
    Aug 2007
    Posts
    300
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    24

    Default

    hm,so i downloaded it, opend the database, but i wasnt able to edit the database.
    i've created a SQL file with all the "insert into .." messages from the 1.1.4 files, removed the row_id of course (to not overwrite the old messages).

    however, i always gets "no such function: read" error.
    this is supposed to be something with the triggers (acordung to another thread), but i wasnt able to fix it.



    so i guess there is no way into importing 1.1.4 messages into an already existig 2.0.0 table

  4. #4
    Senior Professional Array

    Join Date
    Aug 2007
    Posts
    300
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    24

    Default

    okey, i read that i could make somthing with these effing triggers.
    remove them, insert my old SMS and then rebuild the triggers.

    however, the message group ID are different on the two sms.db files, so i would have to, i dont know, script a programm that reads first both DBs and builds the whole sms.db from scratch with new messageids and al that stuff.

    it might work, but you think its worth the trouble?

  5. #5
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by fabiopigi View Post
    okey, i read that i could make somthing with these effing triggers.
    remove them, insert my old SMS and then rebuild the triggers.

    however, the message group ID are different on the two sms.db files, so i would have to, i dont know, script a programm that reads first both DBs and builds the whole sms.db from scratch with new messageids and al that stuff.

    it might work, but you think its worth the trouble?
    Well, I would not go for it. dont know if there are any sms in your history you really want to keep, but...
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2


  6. #6
    Newbie Array

    Join Date
    Feb 2009
    Posts
    3
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Quote Originally Posted by fabiopigi View Post
    okey, i read that i could make somthing with these effing triggers.
    remove them, insert my old SMS and then rebuild the triggers.

    however, the message group ID are different on the two sms.db files, so i would have to, i dont know, script a programm that reads first both DBs and builds the whole sms.db from scratch with new messageids and al that stuff.

    it might work, but you think its worth the trouble?
    Have a look at https://smsmerge.homedns.org/. Somebody did the work already

  7. #7
    Senior Professional Array

    Join Date
    Aug 2007
    Posts
    300
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    24

    Default

    hey simi, thanks for the link, looks exactly what i wanted to have
    it seems you made the script.
    what happens if the group IDs are different in the two databases?

    btw: do you have paypal?

  8. #8
    Newbie Array

    Join Date
    Feb 2009
    Posts
    3
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Quote Originally Posted by fabiopigi View Post
    hey simi, thanks for the link, looks exactly what i wanted to have
    it seems you made the script.
    what happens if the group IDs are different in the two databases?

    btw: do you have paypal?
    The group IDs are rebuilt from scratch. The logic is not very advanced(conversations with multiple recipients are not merged), but it works for me.

    PP is available by PM.
    Last edited by Simi; 02-17-2009 at 10:32 PM.

  9. #9
    Newbie Array

    Join Date
    Apr 2008
    Posts
    1
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Hello there, this is EXACTLY what I'm looking for, having gone through the same steps as OP. The server seems to be down, however, does anyone have a copy of the script available?

    Thanks.

  10. #10
    iPhone Moderator Array

    Join Date
    Aug 2007
    Posts
    3,620
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    220

    Default

    Quote Originally Posted by defect17 View Post
    Hello there, this is EXACTLY what I'm looking for, having gone through the same steps as OP. The server seems to be down, however, does anyone have a copy of the script available?

    Thanks.
    Try a pm to member Simi
    Read the stickies and search the forum before posting!
    If you want to become a Hackint0sh supporter click here
    ----------
    iPhone 4 factory unlocked, iOS 4.3.1, jailbroken
    iPad Wi-Fi + 3G (1G), iOS 4.3.1, jailbroken
    iPad 2


 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 0
    Last Post: 11-17-2010, 07:00 PM
  2. Replies: 0
    Last Post: 09-26-2010, 04:50 PM
  3. MacNN: Casio, Hitachi, NEC to merge phone business?
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 08-28-2009, 03:20 PM
  4. MacNN: Samsung files touch-free patent to control phones
    By hackint0sh in forum Latest Headlines
    Replies: 0
    Last Post: 04-18-2008, 08:40 PM
  5. PHP + Sqlite
    By fabiopigi in forum Free Toolchain Software (Cydia App's)
    Replies: 0
    Last Post: 10-13-2007, 11:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 07:20 PM.
twitter, follow us!