Results 1 to 3 of 3

Thread: Joins Across Servers/Databases

  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Joins Across Servers/Databases

    I am trying to determine how best to create a query that will allow me to perform 'joins across servers'.

    I want to create a single join that will join my production database (Oracle) with my Land Database (MSSQL) on a common key.

    From what I have gathered on other sites, it appears that SQLServer can perform this function, but I am not that technical and I am not a SQL programmer (eventhough I have access to one), and I am hoping there are some point and click apps that will let me perform this function.

    Any thoughts ?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    This can be done using Linked Server.

    You can create a linked server to Oracle from Enterprise Manager in SQL Server. To do this you need to install Oracle Net80 client in the SQL Server and create proper TNSNAMES.ORA file.

    Once you have linked server setup, you can join tables in Oracle to tables in SQL in any SQL Statement.

    Refer to MS article on this

    http://www.microsoft.com/sql/techinf...dingoracle.asp

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Here is an article on linking sql servers to different hetrogenous servers.

    http://www.databasejournal.com/featu...le.php/1756161

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •