sql server replication: 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

[quoted text, click to view]

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)

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.

[quoted text, click to view]