I am bizTalk server newbie too, but I know a lot about mssql server. I am not sure you really need to use biztalk server to solve your problem. Functionality you described is well supported by sql server itself.
If your databases are on the same server you can use a trigger. If they are on different servers you can use replication.