This is precisely what we are doing now...

"Since you are using SQL Server 2005 (this is posted on a SQL Server 2005 forum), instead of triggers executing stored procedures...

Thanks to all for the replies.

We cannot go for transactional replication (I am assuming that for transactional replication the databases have to have the same schema). The reason being...