Tag Historian - Moving tags between gateways

Ignition
1

I have a gateway which has been a combined frontend/backend gateway, which has several other backend gateways connected to it.

It has been decided that this should now become a dedicated frontend server, and we want to move the connected devices and tags to a new backend server, and delete all tags on the existing gateway.

Most of the tag history is not critical to move over, but the customer has a few tags (30 or so) that he would like to be accessible on the new server.

We would like the old tag history to be combined with the new.
What would be the best way to do this, without messing up the taghistorian database?
Can I just do a sql query to edit the "tagid" field from the old data partitions to match the tagid for the new backends tag?

2

I don’t have a validated solution to offer here yet, but just wanted to chime in that I’m dealing with basically the same case right now - I need to migrate some tags off of an old historian to a new historian, I don’t want to migrate entire partitions/tables since most of the tags are not relevant.

Right now I’m looking at setting up scripts to read through old history for a given tag and write all the old points into the new historian, but this seems like a pretty rough way of doing things - and I’m not completely sure yet how nicely it’ll play with historian partitioning when the “written time” differs from the “historical timestamp” (especially since I’m running TimescaleDB on my database)