Marco Gaiarin a écrit : > > > But we have the 'XML dump' in place: and if we simply import an XML > backup adding some fixed amount to the ID of the row? > ID are not infinite, every table have one or more id but are strictly > bound and known (by the schema). > > An import function can have simple switch: > > a) cleanup the database and insert > b) add to database > > in 'add mode' firstly we scan all the tables seeking max(ID)+1 values; > the we alter the xml adding to every ID this fix amount, and then we > insert. > > > In this way we have merged the two database. Could be? > >
Hi, your solution may works but you need to take care of : - link tables - autoincrement value of each table after your process. If you do such a script, you can publish it on the user wiki. regards Julien _______________________________________________ Glpi-user mailing list Glpi-user@gna.org https://mail.gna.org/listinfo/glpi-user