Home » RDBMS Server » Server Administration » create a distributed database on two servers
create a distributed database on two servers [message #610586] Fri, 21 March 2014 09:29 Go to next message
Oussama
Messages: 6
Registered: March 2014
Junior Member
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 on 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
Re: create a distributed database on two servers [message #610587 is a reply to message #610586] Fri, 21 March 2014 09:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

you should start Reading The Fine Manuals at URL below

http://www.oracle.com/technetwork/database/enterprise-edition/documentation/database11gr1-087487.html
Re: create a distributed database on two servers [message #610588 is a reply to message #610587] Fri, 21 March 2014 09:42 Go to previous messageGo to next message
Oussama
Messages: 6
Registered: March 2014
Junior Member
Hi,

It's my first topic here and I really need an answer for my problem as soon as possible, that's why I wrote this fast

I don't see why I have to read the whole Oracle documentation. I want to do sometihng specific ...
Re: create a distributed database on two servers [message #610589 is a reply to message #610588] Fri, 21 March 2014 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
In theory, theory and practice are identical. In practice, theory and practice are unrelated.

>so as I could run SQL queries on any of the machines and get data just like if it was a single database.
In theory, it could be done. In practice it would be messy & borderline unmaintainable.
Re: create a distributed database on two servers [message #610590 is a reply to message #610589] Fri, 21 March 2014 10:07 Go to previous messageGo to next message
Oussama
Messages: 6
Registered: March 2014
Junior Member
I know, but I just want to do it with a really simple database (two columns ID and name for example) just to see how it could be done in practice
I'm not trying to implement it in an Entreprise, I know it would be messy
Re: create a distributed database on two servers [message #610591 is a reply to message #610590] Fri, 21 March 2014 10:11 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Read up on RAC and dataguard.
Re: create a distributed database on two servers [message #610592 is a reply to message #610590] Fri, 21 March 2014 10:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You are free to proceed.
You don't need permission from anyone here.
Previously posted documentation shows how to inter-operate with SQL Server database.
So have at it.
I hope you will enjoy this exercise in futility.
Re: create a distributed database on two servers [message #610593 is a reply to message #610591] Fri, 21 March 2014 10:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
cookiemonster wrote on Fri, 21 March 2014 08:11
Read up on RAC and dataguard.

RAC & SQL Server do not mix
>and the SQL SERVER 2012 software on the second one
Re: create a distributed database on two servers [message #610596 is a reply to message #610593] Fri, 21 March 2014 10:44 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It's somewhat possible of course.

You can create a Link from SQL Server to Oracle via the "Linked Server to Oracle" functionality in SQL Server for one direction.

For the other direction you can create a "Database Link" in Oracle via Oracle "Heterogeneous Services" to connect to the SQL server.

It's not really trivial of course, and you will never really be able to use it "as if it were the same database" It might work for 50% of the "standard" SQLs you can come up with, but most of the time you have to tweak the SQLs you run pretty much so that they work sufficiently over the link. And "running identical queries on both sides" would be really hard to achieve.

[Updated on: Fri, 21 March 2014 10:45]

Report message to a moderator

Re: create a distributed database on two servers [message #610597 is a reply to message #610596] Fri, 21 March 2014 11:04 Go to previous messageGo to next message
Oussama
Messages: 6
Registered: March 2014
Junior Member
I understand that running identical queries would be hard to achieve, but this is not a problem

Like I said I just want to test the operation using one or two basic simple sql queries (like select name from table) because what is important for me is to just make it work

So can you explain to me how I can in practice, create a Link from SQL Server to Oracle and a Database Link from Oracle to connect to the SQL server with steps assuming I have a database called db and a unique table called employee with one column called ID (something really simple, the purpose is just to make it work)

Thanks in advance
Re: create a distributed database on two servers [message #610602 is a reply to message #610597] Fri, 21 March 2014 12:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As this have been addressed many times you can easily find the answer here and on the web without we have to repeat it.
But you are free to then put here the complete solution you will find and test.

Re: create a distributed database on two servers [message #610619 is a reply to message #610602] Fri, 21 March 2014 18:40 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Hint: The words I put in quotation marks give pretty good Google results on the subject, with a lot of step-by-step instructions. Razz
Previous Topic: ORA-01034: ORACLE not available (some users only)
Next Topic: Confusion about nologging
Goto Forum:
  


Current Time: Thu Mar 28 05:07:11 CDT 2024