Sync table in two different database (different Server)

• Minnu

  SSCertifiable

  Points: 6451

  More actions

  July 14, 2016 at 3:05 am

  #315029

  Hi Team,

  Below is my scenario.

  Server 1

  Database Name : UNIFY

  Table Name : User

  No.of Columns : 50

  String Datatype : Varchar

  No.of Records : 10000

  Server 2

  Database Name : UNIFY

  Table Name : User

  No.of Columns : 60

  String Datatype : NVarchar

  No.of Records : 10000

  - In Server 1 – when the no.of records = 10000, Database backup taken from server 1 and stored on Server 2.

  - There are many transactions (INSERTS / UPDATES) done on Server 1.

  - And there are few columns added in Server 2 Database.

  - Now all the transactions (INSERTS / UPDATES) happened in Server 1 and the number of records in server 1 table is more than 20000, now i need to sync the server 2 table with server 1 table.

  - Server 2 Database should be the final database for use.

  what is the best method to sync the server 2 table with server 1 table.

  i tried to sync using tablediff.exe, but due difference in structure, unable to sync the table.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 14, 2016 at 3:14 am

  #1890020

  Have you considered replication?

  John