Create a distributed database on two servers

  1. lam xuyen

    lam xuyen Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    hcm
    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

    Messages:
    778
    Likes Received:
    149
    Trophy Points:
    830
    Location:
    Russian Federation
    wael_wr30 likes this.