# \[IGN-1036\] Use relative path to ignition folder in SQLite Connect URL

**URL:** <https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490>\
**Category:** Ignition\
**Created:** [November 10, 2020, 3:01pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490 "2020-11-10T15:01:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [November 10, 2020, 3:01pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490/1 "2020-11-10T15:01:23Z")

</div>

Hi,

I want to use a relative path to ignition installation folder in SQLite Connect URL, so when I backup and restore my gateway from a windows OS to Linux the URL still working for me.  
What is the correct syntax for it?

For example:  
C:/Program Files/Inductive Automation/Ignition/data/projects/HMI.db  
to some thing like that:  
./data/projects/HMI.db

---

<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:** [November 10, 2020, 4:24pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490/3 "2020-11-10T16:24:31Z")

</div>

There’s supposed to be functionality to do this using a placeholder in the connect URL, but it isn’t working in 8.1.0 - we’ll provide this in an upcoming version.

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [November 10, 2020, 5:39pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490/4 "2020-11-10T17:39:49Z")

</div>

Greate. What is the syntax?

---

<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:** [November 10, 2020, 5:47pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490/5 "2020-11-10T17:47:11Z")

</div>

It will likely be a placeholder in the URL you provide at the database connection - something like `${data}/path/to/file.db`, where `${data}` automatically resolves to the local gateway’s data directory.

---

<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 4, 2021, 5:57pm UTC](https://forum.inductiveautomation.com/t/ign-1036-use-relative-path-to-ignition-folder-in-sqlite-connect-url/40490/6 "2021-08-04T17:57:22Z")

</div>

> [@Nightly 8.1 Changelogs - 2021](https://forum.inductiveautomation.com/t/nightly-8-1-changelogs-2021/42410/130):
>
> Nightly Changelog: 8.1.9-b20210804 Security 1279 8.1: Add option to control how much information is given to clients/designers in error messages Gateway errors sent to the designer or client containing external system details can now be suppressed via an optional system property. 588: Limited license parsing needs to ‘fail-open’ if restrictions are malformed/invalid Prevented a NumberFormatException from being thrown when parsing invalid license restrictions for limited vision client & repo…

8.1.9 adds support for `${data}` and `${local}` as placeholders in SQLite's connect URL.
