I'm not sure if this is possible. Looking for some help with a specific issue. I am building an iPhone application with a data layer written in Ruby that will connect to SQL Server 2008. For various reasons, I need to separate the iPhone application from the servers that power my websites. The databases will be hosted on separate servers, and the tables will need to be laid out differently, but I need to push some information from the one database into the other database automatically and instantaneously.
Example: Someone makes a change on the website, updating the website DB. This website DB has a table which will need to be pushed onto a differently named table on a different server.
How can I go about doing this?