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.

Reply to this topic

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: