Announcement

Collapse
No announcement yet.

Can I query between NaviCat Connections?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can I query between NaviCat Connections?

    I have several connected databases, which I canNOT alter. I can NOT get anyone to establish sever links. Click image for larger version

Name:	NaviCatl Connections.JPG
Views:	2
Size:	18.2 KB
ID:	4500
    All the ones I want to connect are SQLServer.
    See attached Image.
    They have related, but different, business data.
    Can I write a query in any of them to select data from several connections at once?
    I tried GoldPoint . dbo . <DBname> . <table>
    LEFT JOIN NLS . <DBname> . <table>

    Did not work
    Any ideas? is it even possible?
    Thanks all in advance!
    Attached Files

  • #2
    If you do not have linked servers, you cannot to access data in other SQL Server instances.

    For more information, please refer to - https://msdn.microsoft.com/en-us/library/ms188279.aspx

    Comment

    Working...
    X