# Join different database connections 2024

**URL:** <https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563>\
**Category:** Ignition\
**Created:** [February 12, 2024, 4:11pm UTC](https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563 "2024-02-12T16:11:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zach\_Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zach_larson/32/54388_2.png) [@Zach\_Larson](https://forum.inductiveautomation.com/u/Zach_Larson)\
**Post date:** [February 12, 2024, 4:11pm UTC](https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563/1 "2024-02-12T16:11:04Z")

</div>

I saw a 2016 post saying you can't join across different database connections.  
Both are MS SQL.

So I need to request a table be replicated/duplicate it myself?

Or is there a good solution I don't know about?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [February 12, 2024, 4:13pm UTC](https://forum.inductiveautomation.com/t/join-different-database-connections-2024/85563/2 "2024-02-12T16:13:46Z")

</div>

If both are SQL Server you might be able to link the servers together and join across tables, letting SQL Server take care of the remote queries. Not 100% though.

It would be transparent to Ignition. You would have a connection to just one server, and write queries against just one server, and it would have to provide access to remote tables as if they were local.

> **[Create linked servers - SQL Server](https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver16)**
>
> Create linked servers (SQL Server Database Engine)