SQL redundant databases both sets being modified independently yet staying concurrent
SQL Server has various flavours of replication with different capabilities.

It sounds like peer-to-peer transactional replication best fits your needs.