Thread:Jaxdog/@comment-1715389-20130713193616/@comment-10698797-20130716124058

For Windows: Have Office Access and bet a ODBC driver for sqlite. Create a user DNS to old and new sqlite. Embed the zbsmanagedships as shipold and as shipnew, the zbsmanagedunits as unitold and unit new as external data in a access-db. Look in shipnew for the highest value of z_pk(z_key). Choose a save offset, so the z_pk will stay unique in the new table. Open a new query in sql view. Write "insert into shipnew(z_pk, complete list of fields) select (z_pk + offset, complete list of fields) from shipold where z_pk is in (50, 67, - list of z_pks of the ships you want to transfer). Run this statement. Same game with unitold and unitnew with the differences that in the select clause to field Zship the same offset has to be added as you used above and in the where clause it must be zship than z_pk.