Database Mirroring

I want to set up two databases that have exactly the same schema in two different locations.

I would like to know how I can do database mirroring, where both of my databases will look exactly the same, that is the data is exactly the same or almost the same at any given time.

I was wondering if there are any tools out there that I can use to do this type of database mirroring or would I have to develop something like a trigger on the databases to propogate the data changes over to the mirrored database.

Thanks a bunch.

-- 


====================================================================

PETER CHAN, Northern Telecom
PHONE: (613) 763-9096   FAX: (613) 763-4408   EMAIL: chanp_at_nortel.ca


====================================================================