transfer scripts from old to new database have been developed
Transfer scripts from old to new database have to be developed.
For transferring the old database into the new schema the REST API will not be used (as this is only done once and should be done as fast as possible).
A special challenge will be the transfer of station data where the same station of different networks will now be represented as one(!) entry in the new stationmeta_core table (with all codes listed in this entry).
A first try will compare:
- station_id and station_local_id of old_database with codes of already inserted stations in new database
- station_coordinates of old database with those of already inserted stations in new database (within an accuracy of 4/5 digitals)
All combinations automatically found will be logged.
Also, all pairs of old values for station.id and new values for stationmeta_core.id will be logged to be able to transfer the time-series metadata correctly.
Open questions:
Should timeseries_id be kept?