For Snapshot Replication of source (PUBLISHED) tables containing IDENTITY columns, do I need to proactively do "anything" to ensure the propagation of these columns contents as is?
In this table of 3 rows (ID values = 1,2,3)
CREATE TABLE [dbo].[Application] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (100) NOT NULL ,
[Status] [nchar] (10) NOT NULL
) ON [PRIMARY]
Will the subscribing table receive the ID values 1,2,3 in the default setup of SNAPSHOT Replication?
In this table of 3 rows (ID values = 1,2,3)
CREATE TABLE [dbo].[Application] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (100) NOT NULL ,
[Status] [nchar] (10) NOT NULL
) ON [PRIMARY]
Will the subscribing table receive the ID values 1,2,3 in the default setup of SNAPSHOT Replication?