We are planning to upgrade my DEV,QA and Production environments from SQLSERVER 2000 to SQL SERVER 2008 R2. And planning to implement the Transactional Replication in SQL SERVER 2008 for Production environment.
We have frequent releases to Production like monthly once. In those rleases we might be modifying the articles (TABLE, VIEWS,SP,FUNCTIONS and TRIGGERS). Could you please let us know the best way to implement the Transactional REPLICATION and pre-requisites
for this process.
We had faced some problems in SL SERVER 2000 for Transaction Replication. When ever we are using any ALTER TABLE scripts in this replication.The replication has broken.
Could you please provide the best practices if you have?
Thanks in advance
View Complete Post