Synchronise 2 Sql Server Databases

See more:

SQL-Server-2005

VB

SQL-Server

Hello, this is Vikash.

I have 2 Sql Databases with Identical tables and their structures.

What I need to do is, Synchronise DB2 with latest records from DB1, in each table.

eg. Say DB has Employee Table Emp.

DB1.Emp has 6 records
1-A
2-B
3-C
4-D
5-E
6-F

DB2.Emp has 4 records
1-A
2-B
3-C
4-D

I want the 2 records in DB1.Emp get inserted in DB2.Emp

I know I can do this using VB.net looping through each tables record in DB1 and inserting into DB2.

But is their any other way, or command in sql server to bulk copy this data.

Any help would be great.