Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 16:18:11
|
IceEyes writes "Hi,
I have a problem that I could not figure out myself so here comes the question:
I have a SQL 2000 Server (running on Win 2K Advanced Server) interacting with a Web Application. The Web Application makes some insert/update/deletes on some tables on SQL 2000.
There is an Oracle 8i computer (running on HP-UNIX 11 32-bit) that needs to get the SQL tables replicated to itself so that another application on Oracle side can make further updates on those replicated tables. Then I need to push back the final version of tables to SQL 2000, so it can return the results to the Web Application.
If there would be two SQL Servers, instead of one SQL and one Oracle, I would be able to use the Merge Replication feature.
I have read the SQL Server white papers on replication and there it says that Merge Replication is possible with heterogeneous systems, but only if you're willing to write your own application that makes use of SQL-DMO or RMI. So that functionality does not come built-in to SQL Server.
What shall I do to accomplish a Merge Replication (or bi-directional replication) within a SQL/Oracle environment? There are various 3rd party software that claim they can do the job, as well as Oracle's Replication Services software...
Anybody has a real-life experience with this? Any advice, comment?
Thanks in advance..." |
|
|
|
|
|
SQL-Oracle-SQL Replication