We have a requirement as below. We need a bi-directional replication. i.e from Oracle 10g to multiple Sql Server 7.0 servers and multiple Sql Server 7.0 servers to Oracle 10g at specified intervals. There are around 300 tables in the Oracle database and each Sql Server database. Every 30 minutes a sync has to be made from Oracle to all Sql Servers only for the inserted/modified/deleted data. And with a difference of 5 min each there has to be sync from all SQl Servers to Oracle (eg Sql Server 1 to Oracle at 10:00 am, Sql Server 2 to Oracle at 10:05 am etc..) Also we need a feasibility to set up some rules as to what filters have to apply on the data.There are 35 tables which have to be synched without any filters and the rest of the tables should replicate data between servers based on the rules. Also the tables in Oracle database and Sql Server databases have the same table names and table structure. But the schema name in Oracle is different in Oracle and Sql Server (all Sql Servers have same schema name) Also we need a option to do a full refresh/delta refresh. Can all this be possible in Sync Framework.
The providers that are included as part of Sync Services for ADO.NET officially support SQL 2005 and greater, however with the Sync Framework you could write your own provider if the provided ones do not fit your needs. Would all the SQL Servers sync only with the Oracle or would they also sync in a peer-to-peer fashion? In terms of the synchronization duration, are you saying that the sync from SQL Server 1 to Oracle must complete in 5 minutes before the sync from SQL Server 2 to Oracle begins, or would overlap be acceptable as long as conflicts were detected correctly? Across the 300 tables, typically how many changes would be sent from Oracle to SQL every 30 minutes?
