How big is the table you are attempting to synchronize?
If the table is big, you may just want to BCP is into MS SQL Server
and let the server produce a table that you can bring into VFP.
If the table is not that big, pass the VFP table to MS SQL Server
and have still have the backend produce a table that you can bring
into VFP.
If the table is small, VFP scanning through SQL PassThru will be
your easiest solution.
>Is there a "Fast way" to synchronize a MS SQL server tables with VFP tables. I have tries to create remote views in VFP to use the view in VFP and scan though it but it seems to take a long time to load and run. I have tries to do SQLEXEC and SQLPREPARE and that seems slow too. Can I do this on MS SQL side or is it just going to be slow? Any help would be appreciated.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement