Synchronization between two same databases in SQL Server and Firebird

I have same databases in SQL Server2005 and Firebird, how can i synchronize these two databases. My application is there in both window base and web base, some features in window application and s开发者_C百科ome other features in web application. for window application we are using firebird2.5.0 and for web application SQLServer2005. If any changes occur in SQL database through web application, same changes must happen firebird database also. like that if any changes in firebird database then same changes must happen in SQL database also. how its possible.

---

I think CopyTiger can help you

---

Depending on the complexity of synchronization rules, I might find yourself having to implement/code that. I'm sure there are tools for sync, but I'm also pretty sure that tools seldom resolve complex issues.

There are tons of ways of doing this. We would need to know more details of your structure and environment.

---

I believe that Daffodil Replicator supports both Firebird and MS SQL.