Am Montag, 30. Mai 2016, 20:13:16 schrieb tatooin: > I am looking at merging two OpenVAS databases into one. Both databases > are installed currently in two different openVAS servers, and I would > like to have a global database to that everything is available to GSA in > one administration interface. > > There may be duplicates in the databases, but it's ok, I can do the > manual cleanup later. > > I tried to merge both sqlite DB using the following method: > > sqlite3 database1 .dump >fileall.sql > sqlite3 database2 .dump >>fileall.sql > sqlite3 database3 <fileall.sql > > But it doesn't appears to do the job properly, as the database3 contains > targets from database1 & database2, but raw data (reports) from > database2 are missing. > > Am I missing something ? (sorry I really don't know much about databases > in general)
merging directly two databases is not supported and can get extremely hairy. Unless you know the entire datamodel blindly you should not try this. -- Dr. Jan-Oliver Wagner | +49-541-335084-0 | http://www.greenbone.net/ Greenbone Networks GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B 202460 Geschäftsführer: Lukas Grunwald, Dr. Jan-Oliver Wagner _______________________________________________ Openvas-discuss mailing list [email protected] https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
