Identity column problem in SQL replication

How can we transfer primary key (iden开发者_JS百科tity column) while replicating a database.

---

You'll need to set the tables IDENTITY_INSERT to on and after everything is done turn it back off again.

SET IDENTITY_INSERT test ON

-- Inserts

SET IDENTITY_INSERT test OFF

But for more info and exceptions check this great article.
http://www.simple-talk.com/sql/database-administration/the-identity-crisis-in-replication/

---

If you're talking MySQL, a simple export/drop/create process should work just fine.

---

Remove the "identity" definition on your target table and you can copy directly from the source table. This will only work if the replication is one-way.