Solved

Error on replication

Hi. When I try to replicate a MS SQL 2005 database the following message is shown:

"Verify the support data types Violation os UNIQUE KEY constraint 'PROVIDER_UK2'. Cannot insert duplicate key in object 'dbo.PROVIDER'. The statement has been terminated."

The tables are as follows:

CREATE TABLE Pais (

[siglaPais] [varchar](10) primary key NOT NULL,

[nomePais] [varchar](100) NOT NULL,

)

CREATE TABLE Estado (

[siglaPais] [varchar](10),

[nomeEstado] [varchar](100),

CONSTRAINT PK_ChaveEstado PRIMARY KEY (siglaPais, nomeEstado),

foreign key ( [siglaPais] ) references [Pais] ([siglaPais]),

)

CREATE TABLE Cidade (

[siglaPais] [varchar](10),

[nomeEstado] [varchar](100),

[nomeCidade] [varchar](100),

CONSTRAINT PK_ChaveCidade PRIMARY KEY (siglaPais, nomeEstado, nomeCidade),

constraint fk_estado foreign key (siglaPais, nomeEstado) references [Estado] (siglaPais, nomeEstado),

)

Comments (11)

photo
0

The problem is in virtualization, I am sorry about the spelling mistake, it was done by auto correct.

one more question is there any way to delete the virtualized entity?

photo
0

I have tried this in Replication as well, gives me the same thing. And on a different PC (System)

photo
0

Dear Wajid,

A member of our support team will contact you by email.

Best Regards