SQL Replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Replication

I want to replicate identity columns to my subscriber. This is because, when my application has to be brought up at the subscriber, it looks for these identity columns. But once i start the transactional replication,these identity propery is turned to "no" at the subscriber.
Please guide me….
We are preparing for disaster recovery using SQL Transactional replication.
Replication is not bi-directional. So updates wont take place on the both ends every time. Only when the primary databse is down, the application will be bought up using the secondary database. Riya
Kindly post the thread in relevant forums. Take help of this articlehttp://www.databasejournal.com/features/mssql/article.php/3483421 for further information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>