Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mhbdba
Starting Member
8 Posts |
 Posted - 2007-09-21 : 11:44:52
|
| I did a schema comparison of two databases and the difference is:[DO_NOT_SELL_LIST_ID] [int] NOT NULL IDENTITY(1, 1),AND [DO_NOT_SELL_LIST_ID] [int] NOT NULL IDENTITY(1, 1) NOT FOR REPLICATION,So, only difference it shows is "NOT FOR REPLICATION" only on Identity Column, What does this mean? Thanks, will appreciate any help. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-21 : 11:49:14
|
| A remote, replicated server, will be allowed to insert its own IDs, and not generate fresh ones as a local process normally would.Usually you also stick a CHECK constraint on both databases participating int eh replication so that the Identity ID ranges allocated by each can't overlap!!Kristen |
 |
|
|
|
|
|
Identity