Is there an MSSQL equivalent of MySQL's multi-master replication? If so, is it available in SQL Express 2008? I've also seen it referred to as two node circular replication.
Basically, I have an in-office database that I want to be perfectly (relatively :) )in sync with a cloud database (we will have access via VPN). Reads and writes occur at both nodes.
Peer-to-Peer Transactional Replication. Is an Enterprise only feature. Another option is an updatable subscription for Transactional Replication, see Updatable Subscriptions for Transactional Replication. And finally you can roll your own using Service Broker, which is the only option which will work with an Express client, as long as the 'cloud' edition is non-Express.