Import old database by merging two databases
2 posts · Closed
Hi.
I recently had a drive failure and had to reinstall. A few days after, I managed to recover old NetWorx files.
Is it possible to import an old DB by merging the two databases, not replacing one for another? I seem to remember there being a way but can't remember how I did it before (or I might remember wrongly and it was another app).
Thank you
It is possible, with some skills required. You would need to download an SQLite database manager, for example SQLiteSpy:
Then you have two DB files (old and new) you can transfer the data from the new one to the old one by doing the following:
- Run SQLiteSpy
- Choose File - Open Database and open the old file (it should display as 'main')
- Choose File - Attach Database and open the new file (it should display as 'networx'.
- Type in the following query:
INSERT OR IGNORE INTO main.usage SELECT NULL, USER_NAME, DAY, HOUR, DATA_IN, DATA_OUT, DIALUP_DURATION FROM networx.usage
- Choose Execute - Execute SQL.
This will only transfer usage data, but not applications or visited web-sites. I also recommend to backup the databases before merging, in case something goes wrong with the transfer.