Home » RDBMS Server » Server Administration » how to synchronize between tow schema separated on tow databases (merged 4)
how to synchronize between tow schema separated on tow databases (merged 4) [message #426131] Wed, 14 October 2009 03:13 Go to next message
mahora81
Messages: 2
Registered: October 2009
Location: ALEP
Junior Member
how to synchronize between tow schema separated on tow databases

Report message to a moderator

Re: how to synchronize between tow schema separated on tow databases (merged 4) [message #426137 is a reply to message #426131] Wed, 14 October 2009 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It depends on what you actually want to do and if the schemas have independent lives or not and so on.
So detail your question.

Regards
Michel

Report message to a moderator

Re: how to synchronize between tow schema separated on tow databases (merged 4) [message #426143 is a reply to message #426131] Wed, 14 October 2009 03:34 Go to previous messageGo to next message
mahora81
Messages: 2
Registered: October 2009
Location: ALEP
Junior Member
What database version ? 11 g
Are they the same database version ? one of 8i and the new is 11g
Do they use the same character set ? yes
Are they on the same OS ? no
What kind of storage ? file system
Is there a network connection ? yes
What objects are in the schemas ? tables & sequnces
Is this a one-off, or do you need them kept the same ? i need them kept the same



What is the transaction volume ? small
How many tables and how many sequences ? all
How big are the tables ? very much
Do the tables need to be synced up to the second , or is once per day OK ? synced up to the second

Report message to a moderator

Re: how to synchronize between tow schema separated on tow databases (merged 4) [message #426150 is a reply to message #426143] Wed, 14 October 2009 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Answer: no builtin way and I think you can't do it any way.

Regards
Michel

[Updated on: Wed, 14 October 2009 03:44]

Report message to a moderator

Re: how to synchronize between tow schema separated on tow databases (merged 4) [message #426225 is a reply to message #426143] Wed, 14 October 2009 08:06 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Are you looking at one-way or two way synchronisation?
Ie do you just want changes in Db A to propogate over to Db B, or do you also want changes to Db B to go to Db A

Report message to a moderator

Previous Topic: create dimension
Next Topic: Query executions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 12:30:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.