Best way to sync a table between two sql server databases with an identity key
I would go this route:

SET IDENTITY_INSERT &lt;table&gt; ON
...
DBCC CHECKIDENT(&lt;table&gt;)
SET IDENTITY_INSERT &lt;table&gt; OFF


SET IDENTITY_INSERT:
http://msdn.microsoft.com/en-us/library/ms188059.aspx

DBCC CHECKIDENT:
http://msdn.microsoft.com/en-us/library/ms176057.aspx