SQL express replication ???

[serge calderara]

Dear all,

I have a plan to convert a local aplication which actually use MS Access to
implemented with SQL express 2005.
Doing this I need to be able from SQL express to transfer data automatically
to an other Server running SQL server 2000 or 2005.

I was thinking of uisng a scheduling replication feature but I have read
that SQL express can only be a subscriber and not a publisher. Is it true ?

What is the easy way then to automatically transfert predinied table to a
remote server at a specific event from an SQL express source database ?

thnaks fro comments
regards
serge

[Paul Ibison]

SQL Server Express, unlike MSDE cannot be a publisher or a distributor at
all.
It can be a subscriber to any type of replication so this could be used in
your case.
Extra considerations are that for pull subscriptions there is no sql server
agent, but you could use Windows Synchronization Manager or a RMO
programming solution to synchronize. Push subscriptions have the agent work
at the distributor so this'll work as per usual because the distributor
can't be SQL Server Express.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .