# Tag path changed for historian **URL:** \ **Category:** Ignition\ **Created:** [January 15, 2026, 3:40pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319 "2026-01-15T15:40:56Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gbuschman](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@gbuschman](https://forum.inductiveautomation.com/u/gbuschman)\ **Post date:** [January 15, 2026, 3:40pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/1 "2026-01-15T15:40:56Z")
Made a mistake. I created tags for our historian organized in one way. This created tags in the SQL database with that tag path. Manager wanted them organized another way. Same tags, just in different subfolders. Now the SQL database made new tag ID’s with the new path, and there is no link between the data before I made this change. Is there any way to bridge these so we can see them in our trend? Data is all there, but our power chart only pulls from the currently configured path, so there is no way it sees the old data. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [January 15, 2026, 3:48pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/2 "2026-01-15T15:48:13Z")
If you're not comfortable with SQL I'd advise avoid doing this but if you are comfortable making changes then you can just fix it in SQL. Also always backup the data before you make changes. Search the sqlth\_te table and find one old tag path and one new tag path. You'll see the old and new tagid in there, note these down. Go to your sqlt\_data\_x\_xxxx tables and search for those tag ids. You need to update the old tagid to be the new tagid for it to join the data. ---
**Author:** ![gbuschman](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@gbuschman](https://forum.inductiveautomation.com/u/gbuschman)\ **Post date:** [January 15, 2026, 3:50pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/3 "2026-01-15T15:50:25Z")
Awesome, thanks! I know enough about SQL to be dangerous, and that’s how I was able to find out the tag paths were different. I should be able to handle this, and will definitely do a backup before I start. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [January 15, 2026, 3:51pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/4 "2026-01-15T15:51:45Z")
Here's a thread as well. Though this one suggests you can also try editing the sqtlth\_te table instead which if you just made the change and are fine without the new data that's easier. But if this was done a while ago and you're just noticing the data loss then you'd have to do the more manual way. > [@Merge old tag history with rename new tag history](https://forum.inductiveautomation.com/t/merge-old-tag-history-with-rename-new-tag-history/66157): > > Ignition Version 8.1.2 I create a tag and config it history. SQL ID is 5051. Later I rename this tag on 2022-10-19 . SQL ID is 5188. When I query Chart ,I just see the new tag chart. I can't query the old tag and rename new tag chart together. How to merge them together? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 15, 2026, 3:56pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/5 "2026-01-15T15:56:58Z")
> [@Nol](#): > > You need to update the old tagid to be the new tagid for it to join the data. You also need to update the timestamps for the new tag ID to include the valid timespan of the old data. ---
**Author:** ![gbuschman](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@gbuschman](https://forum.inductiveautomation.com/u/gbuschman)\ **Post date:** [January 15, 2026, 4:16pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/6 "2026-01-15T16:16:09Z")
Ok, I’m going to move forward with updating the sqlth\_te table. From what I’m understanding I need to: -Update the old tag paths to be the new tag path -Update the created timestamp of the new tags to be that of the old tag Correct? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 15, 2026, 4:20pm UTC](https://forum.inductiveautomation.com/t/tag-path-changed-for-historian/113319/7 "2026-01-15T16:20:01Z")
No. Either: - Update tag\_ids in data partitions to new tag and update new tag IDs created timestamps, OR - Update tag paths for old tag IDs and set old tag IDs retired timestamps > **[Tag History​ - Ignition Database Table Reference | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/reference-pages/ignition-database-table-reference#tag-history)** > > Ignition has a lot of systems built-in that will query the database automatically without requiring you to build a query. These systems automatically create the necessary tables in the database, insert the relevant data, and even query it back out... Don't forget to disable the history provider while editing the tables. Much of this data is cached in RAM and your edits won't be noticed.