# Store and Forward with SQL Bridge at Remote Location

**URL:** <https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933>\
**Category:** Ignition\
**Created:** [April 26, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933 "2023-04-26T16:21:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeremiah\_Brown1](https://avatars.discourse-cdn.com/v4/letter/j/65b543/32.png) [@Jeremiah\_Brown1](https://forum.inductiveautomation.com/u/Jeremiah_Brown1)\
**Post date:** [April 26, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933/1 "2023-04-26T16:21:20Z")

</div>

Hello,

I'm trying to figure out the best solution to store and forward SQL data at a remote site. The current system setup looks like this.

Central site - Ignition Gateway with SQL bridge with transaction group pushing data to Azure SQL instance. Data is pushed once a minute based on trigger tag.

- Site to Site VPN to remote site
- Central gateway pulls data from 2 PLCs at remote site and pushes to Azure SQL
- If site to site VPN goes down, data is lost

Remote site - Ignition Edge Panel and Sync Services (not configured yet, need to create project)

I need to be able to store and forward data from remote site to Azure SQL when site to site VPN goes down between central and remote site. I know this is possible with Edge Sync services for the central historian (currently Mariadb) but I need store and forward capability for the 1 minute SQL data to Azure.

One option appears to be buying the SQL bridge module for the remote site and setting up a gateway there just for this purpose. Then creating a transaction group for the remote site that pushes directly to Azure SQL. So if central/remote VPN connection goes down or Internet at remote site goes down the SQL data will store and forward.

Curious if anybody has run into a similar issue and what the solution was.

Thanks!

---

<div class="post-metadata">

**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:** [April 26, 2023, 4:25pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-with-sql-bridge-at-remote-location/72933/2 "2023-04-26T16:25:28Z")

</div>

> [@Jeremiah\_Brown1](#):
>
> buying the SQL bridge module for the remote site

Yes, this can use that remote site's S&F system. Note, not available for Edge. Edge cannot talk to databases.