Hello, I have the original H2 database filled with an interesting position history for several vehicles, now I would like to add it to my current mariadb database by simply importing data from the positions table.
I find the following doubts:
I know I have to change devices ID from old table to match new one, but how about event IDs?
May I change H2 event IDs in order to make them correlate (bigger than) the ones that already are on mariadb or should I change mariadb ones in order to give them bigger numbers than the ones from H2 so date and events ID are all ordered the same way?
(or maybe there can be duplicate event IDs)
I Hope is understandable...
Either option should work, I think.
Hello, I have the original H2 database filled with an interesting position history for several vehicles, now I would like to add it to my current mariadb database by simply importing data from the positions table.
I find the following doubts:
I know I have to change devices ID from old table to match new one, but how about event IDs?
May I change H2 event IDs in order to make them correlate (bigger than) the ones that already are on mariadb or should I change mariadb ones in order to give them bigger numbers than the ones from H2 so date and events ID are all ordered the same way?
(or maybe there can be duplicate event IDs)
I Hope is understandable...