Hi

With the info provided, I would consider replication, simple enough and effective. Do you need to go back the other way or it will be 1-way replication only?

Another option is simply a bunch of "smart" triggers that do the same sort of thing, perhaps into a staging table and reapplies the DML back in order at the other end. We did this between oracle and sql server and very rarely failed (it was a super huge courts based app).

If you do go down the replication end, take the time to setup a test env and walk yourself through the recovery senarions.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"