Replication between MSDE and SQL Server 2000

I got a corporate machine has SQL Server 2000 installed. And a laptop has
MSDE installed. Is this complicated to setup a 2 way replication in SQL
Server 2000 Enterprise Manager?
Not at all. The MSDE can't be set up as a transactional publisher, and most
people set up the MSDE as a subscriber because of the topology they're using
anyway. Apart from that it's pretty straightforward. Configuration of MSDE
on a separate bix when you can't connect to it using EM can be more
difficult though.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Use merge replication for bi-directional replication. Merge also works with
MSDE.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%23decwk1FGHA.376@.TK2MSFTNGP12.phx.gbl...
>I got a corporate machine has SQL Server 2000 installed. And a laptop has
> MSDE installed. Is this complicated to setup a 2 way replication in SQL
> Server 2000 Enterprise Manager?
>
|||Hi Hilary,
Could you tell me where can I get the detailed steps to set up the
replication process between the SQL Server 2000 and the laptop MSDE ?
As I am investigating the database to do this project, MSDE is an option,
and Firebird is another but I can only find some trial version of components
which have some limitations.
The reason why I need to do the replication is the sales persons bring the
laptop on site and then back to office hook up to the corporate sever
database and the replication can be done on demand or by schedule. So it
depends on if I can experiment that SQL Server 2000 and MSDE is a good
combination, the project will use this combination, otherwise, Firebird or
MySQL.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uFv4DO2FGHA.2320@.TK2MSFTNGP11.phx.gbl...
> Use merge replication for bi-directional replication. Merge also works
with
> MSDE.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%23decwk1FGHA.376@.TK2MSFTNGP12.phx.gbl...
>