Showing posts with label increment1. Show all posts
Showing posts with label increment1. Show all posts

Sunday, March 11, 2012

Export to sqlserver

when i export tables to another database then that table which has columns identity(yes),identity seed=1,increment=1 properties removed on destination table.Why?Identity columns and key constraints are not preserved when using the standard replication service in SQL Server, you must use Transactional Shipping Logs.