I need to replicate few tables from Server A (sql server 2005 enterprise) to server B (sql server 2008 R2 enterprise) for an ACTIVE-ACTIVE environment
I need help deciding the best methodoly to achieve my goal. I was thinking transactional replication or mirroring. Which one do you think is best achieved? and can i get a step by step process to set up?