Join different database connections 2024

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?

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.

1 Like