# Remove a retired database from historical trend tag selector

**URL:** <https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608>\
**Category:** Ignition\
**Tags:** database\
**Created:** [August 3, 2022, 12:34am UTC](https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608 "2022-08-03T00:34:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![simon](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@simon](https://forum.inductiveautomation.com/u/simon)\
**Post date:** [August 3, 2022, 12:34am UTC](https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608/1 "2022-08-03T00:34:55Z")

</div>

Hi,  
I initially developed a project using SQLite as the datbase for historical tag data. I have since installed MS SQL Server and redirected all of my tags with historical trending enabled to this database. The SQLite database only contains some early commissioning data that is not of much value to me.  
Currently I have the two database connections defined (MSSQLSERVER and Sample\_SQLite\_Database). I have not deleted the latter as there still seems to be an average of 0.1 queries per second on this target. I am not sure if this is related to the preinstalled samplequickstart project (Enabled =false now) or whether the gateway itself uses this database to stored its configuration and status.  
I don’t have a problem with SQLite remaining installed but I do want to remove it from the Browse Tags pane of the historical trend PowerChart. Currently both my databases appear with a similar tag structure beneath each one as for a short time historical data was saved in SQLite prior to the migration to MS SQL Server.  
Can anyone suggest how I can remove or suppress SQLite from showing in the Browse Tags pane as believe users of the application will be confused by the duplicate data repositories?

Thanks,  
Simon Fry

---

<div class="post-metadata">

**Author:** ![simon](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@simon](https://forum.inductiveautomation.com/u/simon)\
**Post date:** [August 3, 2022, 12:39am UTC](https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608/2 "2022-08-03T00:39:55Z")

</div>

Note: My application does not include any tags from the Sample\_Tags tag provider.

---

<div class="post-metadata">

**Author:** ![simon](https://avatars.discourse-cdn.com/v4/letter/s/f07891/32.png) [@simon](https://forum.inductiveautomation.com/u/simon)\
**Post date:** [August 3, 2022, 8:44am UTC](https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608/3 "2022-08-03T08:44:24Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/a/8a96f3a898d47e4068146d3d9061c88046456e8e.png)  
Would like to keep the green and remove the orange.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 3, 2022, 4:00pm UTC](https://forum.inductiveautomation.com/t/remove-a-retired-database-from-historical-trend-tag-selector/62608/4 "2022-08-03T16:00:33Z")

</div>

If you don’t care about the history data in SQLite, then you could go in and drop the `sqlth_*` tables in SQLite.