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.

All Forums  General SQL Server Forums  New to SQL Server Programming  SQL server and Oracle replication

Author  Topic  IB Starting Member 4 Posts Posted - 2007-01-10 : 03:21:27 Hello, I have this scenario where a remote SQL server will be populated by web updates and handheld devices. On a central location will be an Oracle database. There will also be updates on the Oracle database. I need to reflect all changes on the SQL server to the Oracle database and vice versa so I need some sort of replication between the two databases. The SQL server location at times will not have connectivity to the Internet so such case all updates in either direction must be put on a queue. What is the best technical solution to the problem I mentioned above? Thank you.