Data Copying

Question

Dear All,

I am using Sqlserver 2008 ,need some requirement

i have two servers , (A &B)

 want if insert Record A -Server Database Table , need to copy same data in B-server Related Database Table.

please give me any solution.

Thank's & Regards

S.DURGAREDDY

Answer 1

Hi,

First you need to create linked server for server B.

And then you can use trigger to perform the insertion in the server B.

There is many other options like replication, you can replicate this table or you can use mirroring.

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 2

Replication will be best - has more enterprise operation friendly features such as SCOM integration, monitoring, etc.