Replicating MSDE & SQL2000

Hi All,
What is the best way to merge/replicate SQL2000 & MSDE? We have an app that
laptop users will be running locally when not connected to the network.
When they come into the office we want their local DB on their laptop which
would be MSDE to connect to the SQL2000 Server and the 2 databases to update
each other.
Any references/websites addressing this would be great.
Thanks
Lee
I think you will want to use merge replication. It was designed for just
this kind of situation. Replication is a rather broad topic. The BOL has
lots of information. I would recommend setting up a couple of test databases
and experimenting with replication, just to get familiar with it.
Jim
"Lee Trotter" <latrotter@.@.@.sympatico.ca> wrote in message
news:epJHkFLVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> What is the best way to merge/replicate SQL2000 & MSDE? We have an app
that
> laptop users will be running locally when not connected to the network.
> When they come into the office we want their local DB on their laptop
which
> would be MSDE to connect to the SQL2000 Server and the 2 databases to
update
> each other.
> Any references/websites addressing this would be great.
> Thanks
> Lee
>