Need some advice here.
I have a DB Server (Clustered) which needs to be replicated to a DR Environment. It is connected to SAN storage.
Currently I have this issue doing replication in SQL 2005.
Whenever there is a drop or alter table, there will be issue doing replication.
Have tested with Mirror Clone from SAN but the target copy will not be usable.
I am looking at the below features:
1) Replicate any tables/views irregardless of whether it has primary key or not
2) Allow for synchronise replication (Synchronous/Real Time)
3) Both database must be allowed to run in Active-Active mode even during replication. (For both Source and Target DB)
4) Any drop/alter table in the Apps DB must be replicated across & reflecteed on the Rpt DB as well.
Appreciate if there are any reply. Thanks.