# Sqltags historian for 2 databases

**URL:** <https://forum.inductiveautomation.com/t/sqltags-historian-for-2-databases/5661>\
**Category:** Ignition\
**Created:** [January 8, 2013, 10:15pm UTC](https://forum.inductiveautomation.com/t/sqltags-historian-for-2-databases/5661 "2013-01-08T22:15:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vahterto](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\
**Post date:** [January 8, 2013, 10:15pm UTC](https://forum.inductiveautomation.com/t/sqltags-historian-for-2-databases/5661/1 "2013-01-08T22:15:40Z")

</div>

Hi

We have couple cases where need to store same historian on 2 different databases.  
Normal SqlTags historian method would be good but is there any easy way to use 2 databases?

Tommi

---

<div class="post-metadata">

**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\
**Post date:** [January 22, 2013, 10:50pm UTC](https://forum.inductiveautomation.com/t/sqltags-historian-for-2-databases/5661/2 "2013-01-22T22:50:11Z")

</div>

I don't believe you can do this currently. You get one history provider per data source but each tag has to choose the historian you want to store to. I think the only way to do this would be to have two sets of tags. Depending on how many tags you have in your system it might be easier and a better idea to look into some sort of database replication solution.

---

<div class="post-metadata">

**Author:** ![catherine.fowler](https://avatars.discourse-cdn.com/v4/letter/c/34f0e0/32.png) [@catherine.fowler](https://forum.inductiveautomation.com/u/catherine.fowler)\
**Post date:** [January 20, 2022, 7:24pm UTC](https://forum.inductiveautomation.com/t/sqltags-historian-for-2-databases/5661/3 "2022-01-20T19:24:12Z")

</div>

For anyone else who stumbles on this and is about to assume storing to two databases still isn’t possible, this has since been introduced: [Tag History Splitter - Ignition User Manual 8.0 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC80/Tag+History+Splitter)

Glad I didn’t stop looking 🙂