Can we use transaction replication for my scenario

  • We need one column value from table1 in SQL Server database to a new column in table1 in ORACLE database

    Can I use transaction replication for this scenario? What should be the best fit for this scenario?

  • Without knowing more details on your setup, transaction replication may be overkill...or not even possible.

    For one table/one column I'd probably just set up a trigger to perform the delete/insert/update as needed - of course this decision would depend on the number of rows in the tables, how often the rows change, and so forth.

    Can you offer any more information?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply