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 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:

  1. Run SQLiteSpy
  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 find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. 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: