this is one of my table in database design

USE [test]

GO

/****** Object: Table [dbo].[Account] Script Date: 11/05/2020 11:18:58 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Account](

[id] [int] NOT NULL,

[dscrm] [nvarchar](20) NOT NULL,

[ObjVer]...

Thanks for your reply

Which replication method can i use to do this without overwrite another database data?

And what can I do with pk column conflict  in table?

I tried use merge...