With MSSQL 2005, is this architecture possible?:
One database instance in site A and another instance in site B
Application in site A updates SQL database in site A
Application in site B updates SQL database in site B
One-way transactional replication pushes Site A updates to site B
One-way transactional replication pushes Site B updates to site A
The idea behind this architecture is for HA/DR purposes. BlackBerry Enterprise Server for Exchange is the application utilizing the database instnaces in both locations. I guess the bottom line question is "Can a SQL database instance be a source and reciever of independent sets of database updates via one-way transactional replication?"