Replication between SQL Express 2005 and SQL Server 2008 Standard

[auspicious]

Hi,

I am a newbie and facing a replication task involving SQL Express 2005
and SQL Server 2008 standard edition. We have developed a POS
application which is expected to run on multiple machines in a store
and then in multiple stores of a chain. The client machines run with
their own copy of sql express. All the sales are recorded first in the
client side db tables. Then this db should connect with a server db
running on sql server 2008 standard and sync its data. Sales data
recorded in the client db needs to be sent to the server but no data
from the sales tables in the server db, passed from other machines,
should be sent to client db tables.

Now a little googling revealed to me that merge replication is good
for such a scenario but it seems that sql express versions can only be
a subscriber and not a publisher. I also found that some people have
discussed such scenario on different forums but i couldn't find a
single concrete example showing how to do it step by step. The answers
to such queries fail to explain how in the absence of publishing
capability sql express' data is synchronized with server side db.

Lastly, if it cannot be done in any straight forward manner, is there
a work around to it. Any help is extremely appreciated.

/ Irfi

[Hilary Cotter]

all you need to do is create a publication on the standard edition sql
server, enable filtering so that each store will only receive its own data,
or use the exchangetype upload only.

Then make your SQL Server Express clients subscribers to this standard
edition SQL Server.

"auspicious" <auspic...@gmail.com> wrote in message
news:4ab16175-8870-4b64...@j19g2000yqk.googlegroups.com...