Mike Sue-Ping
Cambridge, Ontario, Canada
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only