| replication with data transformations [message #75065] |
Fri, 15 June 2001 02:04  |
David
Messages: 110
Registered: November 1998
|
Senior Member |
|
|
I've got a bit of an unusual replication problem: I need to replicate a database and convert a certain amount of column values automatically during this operation. I was thinking along the lines of setting up triggers on the replicated database to perform this action. Has anybody ever tried this sort of soution or have any ideas of how to handle the problem. I have to use replication because I'm running on real time and need access to two identical databases that run on different currencies.
Thanks for any ideas.
----------------------------------------------------------------------
|
|
|
|
| Re: replication with data transformations [message #75081 is a reply to message #75065] |
Thu, 26 July 2001 20:20  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
My replication is a little rusty, but I seem to remember being able to do a complex snapshot which is like replicating a view (joins etc allowed with restrictions). Also - a Materialized View is virtually identical to replication snapshots, so you could set up a MV and then replicate that if necessary?
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
