Need to figure out how the update works for this data, documentation isn't available as to how this process was managed the first time.
Data has been split between Access databases due to size so old process would need to be modified if it was documented
Data in Postgres database looks similar to the data in the access databases but there are differences;
Access allows special characters in column names (%, etc...) and the snapshot uses them heavily in places, these names are replaced in Postgres, but doesn't appear to be a consistent translation i.e. some characters are dropped, some replaced by _ and some are replaced by character codes (% become perc)
Some data is missing (snapshot was changed when split, some columns have been dropped, not too concerned, but may cause issues)
Some column definitions have changed (mostly text lengths being shortened) but will need to make sure this isn't going to be an issue with the tool
Need to figure out how the update works for this data, documentation isn't available as to how this process was managed the first time.