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:

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: