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

Reply via email to