1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

create a distributed database on two servers

Discussion in 'General' started by Benjamin, Mar 21, 2014.

  1. Benjamin

    Benjamin Active Member

    Likes Received:
    Trophy Points:
    Hi everyone,

    I have two Windows XP machines connected as a LAN

    I have installed the Oracle database software on the first one (11g R2) and the SQL SERVER 2012 software on the second one

    I want to create a database (really simple just for test) distributed between both machines (half of data one machine and the other half on the other) so as I could run SQL queries on any of the machines and get data just like if it was a single database.

    Thanks in advance for any answer or help
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Likes Received:
    Trophy Points:
    Russian Federation

    The distributed database as a rule is created on one platform and supported it by means.

    Maybe you speak about the heterogeneous Oracle service?

    Note : You as can set up and the reverse link on MS SQL side