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.
Previous
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