| Replicating a Database to a Remote server [message #75038] |
Fri, 13 April 2001 14:20  |
Ganeshbabu
Messages: 3
Registered: April 2001
|
Junior Member |
|
|
i need to know something about replicating objects in a database from a server to another database in a remote server.
I have 2 Windows/NT boxes running oracle,both are servers and i have to create a database say for an order(with 4 tables) in the 2 NT machines.lets name them databse A in server1 and database B in server 2 if i update or modify or do whatever operation to the database A in the server 1 it should automatically get done in the database B in the second server.this is the requirement of the project.
assuming i have set up win NT and installed oracle in both of them
1)how do i make the 2 machines recognise each other(they are in a LAN)?
2)how do i replicate the action in databse A in server 1 to database B in server 2?
3)how do i make this operations succesful by including a front end tool like VB/Dev2000 to input data and test the updation?
4)also if i have datasbe A and database B with 4 tables can i update them as a whole database or can i do them only for a single table at a time?
i have already posted questions regarding this project and got good answers ,but i want to have as many ideas as possible i'm posting this again.
any help would be greatly appreciated.
-ganeshbabu
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How do i replicate servers [message #75473 is a reply to message #75228] |
Fri, 20 February 2004 19:30  |
Dev
Messages: 28
Registered: May 2001
|
Junior Member |
|
|
hi sir
i wanna replicate 2 servers.
one is the database server(win 2000 server) & other is domain controller(win 2000 server) both r running sql servers.
just few files i to have to replicate on transaction level. on each transaction replication is to be done.
so plz help me in this regard.
ok i will wait for ur reply.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
