1: Windows server 2008 R2
2: SQL server 2008 R2
I have 2 server environments (ENV-A and ENV-B) running SQL server 2008 R2 and I would like to copy records from DB_A.dbo.table1(ENV-A) and append them to the DB_B.dbo.table1(ENV-B) every 15mins.
How to copy data between DBs over the network every 15 mins.
How to append records if the SS# data field in table 1 on ENV-B is null.
Please share with me any articles / examples about how to copy records from one DB to another DB.
Thanks in advance.