Synchronization

#31

Different problem entirely.

You could use merge replication, but that really does not scale.

You could try peer-to-peer replication, but that requires an application
that is aware of which server owns what data.

Personally, I prefer combination of transactional replication and service
broker. Updates happen asynchronously while read requests are immediate.

There is no "click-next" solution to do what you want.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks Geoff,
however my target is not to perform a fail over (although we can use it as
so) .
i need to install the database servers in two different sites (different
physical location connection via the internet VPN ) and i need both
servers
to answer users requests (read/write). it would be faster for the users to
work on a local (same location/site) database instead of connecting to one
remote server.

can we configure the SQL servers to be both pricipals and replicating
their
transcations in the same time?

thanks ,
--
G

"Geoff N. Hiten" wrote:

Sounds like a job for either log shipping or High Performance database
mirroring. Both work asycnronously to copy and synchronize databases.

Log Shipping overview
http://msdn.microsoft.com/en-us/library/ms187103.aspx

Database Mirroring Overview
http://msdn.microsoft.com/en-us/library/ms189852.aspx

Feel free to come back with some more detailed questions on selection and
implementation.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"GUSS" <GUSS (AT) discussions (DOT) microsoft.com> wrote in message
news:38328584-BF88-4ADA-BD37-1109E306EF0D (AT) microsoft (DOT) com...
i want to install an application using SQL 2005 server in two different
location where delays (Latency) in communication could be great. how
can i
install the SQL 2005 on two different servers each with its own
database
and
having the two databases synchronize with each other including all
objects
and forms?

Thanks,

G

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Synchronization

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Synchronization - 10-27-2008 , 02:13 PM