Im doing a migration from server A to server B.
I used transactional replication. Everything replicated nicely, however, the primary key constraint. Identity had auto resetted to 1. (which is not correct).
The table was created as "NOT FOR REPLICATION" <-- is this the main cause? I cant do anything to the database, as i'm not the application owner.
CREATE TABLE [dbo].[ABREV_TOTEXT](
[abrev] [varchar](50) NOT NULL,
[converted] [varchar](50) NOT NULL,
[longtext] [varchar](50) NULL,
[texttype] [varchar](50) NOT NULL,
[abrev_id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
CONSTRAINT [PK_ABREV_TOTEXT] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
now, how do i save the situation? should i mirror the table structure, then do a replication for data?
View Complete Post