How to merge databases

Started by seeker

seeker

How to merge databases   09 June 2017, 05:26

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 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 and it was another app).
Thank you
SoftPerfect Support forum - Andrew avatar image

Re: How to merge databases   09 June 2017, 11:05

It is possible, with some skills required. You would need to download an SQLite database manager, for example SQLite Spy:

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:

  1. Run SQLite Spy
  2. Choose File - Open Database and open the old file (it should display as 'main')
  3. Choose File - Attach Database and open the new file (it should display as 'networx'.
  4. 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  
  5. 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.

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 ********  ********  **     **  **      **  **      ** 
 **           **      **   **   **  **  **  **  **  ** 
 **           **       ** **    **  **  **  **  **  ** 
 ******       **        ***     **  **  **  **  **  ** 
 **           **       ** **    **  **  **  **  **  ** 
 **           **      **   **   **  **  **  **  **  ** 
 ********     **     **     **   ***  ***    ***  ***  

Message: