java - Merging two databases in Android -

java - Merging two databases in Android -

in app have implemented options backup , restore database sdcard. when restore database, must have saved info included backed data. how create possible?

this how restoring database.

restore:

seek { file sd = environment.getexternalstoragedirectory(); file info = environment.getdatadirectory(); if (sd.canwrite()) { string currentdbpath= "//data//" + "packagename" + "//databases//" + "databasename"; string backupdbpath = "/backupfolder/databasename"; file backupdb= new file(data, currentdbpath); file currentdb = new file(sd, backupdbpath); filechannel src = new fileinputstream(currentdb).getchannel(); filechannel dest = new fileoutputstream(backupdb).getchannel(); dst.transferfrom(src, 0, src.size()); src.close(); dst.close(); toast.maketext(getbasecontext(), backupdb.tostring(), toast.length_long).show(); } } grab (exception e) { toast.maketext(getbasecontext(), e.tostring(), toast.length_long) .show(); }

try attach backed current db in way:

sqlite> attach database 'testdb1.db' 'db1'; sqlite> attach database 'testdb2.db' 'db2'; sqlite> attach database 'testdb3.db' 'db3';

sqlite - attach database

java android database import restore