Real time data transfer

[krishnaveer]

Hi, Which method is the best way to transfer realtime data from one sqlserver to another sqlserver. Plz let me know.. Thanx...

krishna veer singh

[J4amieC]

Depending on where you live, possibly carrier pigeon[^] :laugh: For a more traditional approach google database mirroring[^]

[i j russell]

If you are using 2005 or greater then you should look at Sql Server Service Broker as it was designed specifically for your requirement.

[Ashfield]

Do you mean transfer or replicate? For the former, assuming sql server 2005 or later, useService Broker, for the latter google replication.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP