Thank you Cetin.

I'm kinda partial to the MS SQL Server/MSDE/SSE merge/replication thing myself. The other issue we need to worry about is the ORACLE backend. Does MSDE/SSE play with ORACLE? Without investigating, I think not.

Regards,

Mike


>Mike,
>Depending on release date planned you might either use MSDE or SSE as the local data store (or some other engine like VFP,MDB...).
>SQL server, MSDE/SSE merge/replication is best to take offline and then synch IMHO. Creating a VFP database, adding it view(s) and then taking the view(s) offline is another way.
>If, saying much larger data, you mean a database that's over 2Gb then MSDE is out. SSE limit is 4Gb AFAIK.
>Whatever way you go I suggest use PKs that are 'for replication' and that typically is a GUID on all backends.
>Cetin