I don't know Oracle either. AFAIK Mark McCasland is one of the members using Oracle extensively. He might help.
Cetin
>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