[NEWBIE] Replication with MSDE 2000

Hi everybody,
can someone help me about replication ?
I want to install msde2000 on two machines (identical) and keep database
updated like mirroring, so my users can connect to mirrored data if primary
server crashed down.
The two machines are in my LAN with their own IP number
Is it Possible ?
Thanks in advance and sorry of my poor knowledge of MSDE features
Merlinweb
Hi Merlinweb,
Merge replication goes close to doing what you want if you keep it
synchronizing constantly. There is some latency with the updates but that's
ok in many scenarios. It works very well when the servers are on the same
LAN. You will need to consider though, how to make schema changes, etc. as
that introduces quite a few issues.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"il_Leva" <il_levaMACIAO@.hotmail.com> wrote in message
news:41c97bf0$1@.x-privat.org...
> Hi everybody,
> can someone help me about replication ?
> I want to install msde2000 on two machines (identical) and keep database
> updated like mirroring, so my users can connect to mirrored data if
> primary
> server crashed down.
> The two machines are in my LAN with their own IP number
> Is it Possible ?
> Thanks in advance and sorry of my poor knowledge of MSDE features
> Merlinweb
>
|||"Greg Low [MVP]" <greglow@.lowell.com.au> ha scritto nel messaggio
news:uDw9mGI6EHA.2584@.TK2MSFTNGP10.phx.gbl...
> Hi Merlinweb,
> Merge replication goes close to doing what you want if you keep it
> synchronizing constantly. There is some latency with the updates but
that's
> ok in many scenarios. It works very well when the servers are on the same
> LAN. You will need to consider though, how to make schema changes, etc. as
> that introduces quite a few issues.
Thank you very much !
Now I go and search something useful on the net about merge replication.
Cheers
Merlinweb