SQL Server 2005/2008 VFP 9/10Synchronization

Question

Post reply

SQL Server 2005/2008 VFP 9/10Synchronization

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

flextech SSC Enthusiast Points: 172 More actions · Answer 1

John, you should have my contact info in your private box. If not, reply here and I'll resend.

John Esraelo-498130 SSCertifiable Points: 5916 More actions · Answer 2

There is notification that tells me that there is a message but seem to be unable to open it..

hmmm 🙁

Cheers,
John Esraelo

John Esraelo-498130 SSCertifiable Points: 5916 More actions · Answer 3

flextech,

Oh, one thing that I was going to add to your comment was that; probably it would be a good idea to keep the "transaction" log on the VFP side / folder. Thus, if there is a network issue or an SQL server issue then the writing to the "transaction" log would still continue and the records may be picked/retrieved during the next window of opportunity..

thx

Cheers,
John Esraelo

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 4

Wow, I go to bed and the thread goes wild 🙂

SSIS is used to move data from many servers, fairly often, in the new Data collector in 2008, so it should work, but you can't run them every few seconds. Every minute would be the limit.

Having a log of transactions would make some sense, basically your own built in replication. You'd have to alter the application to write there, but if you're doing that, why not have the VPF app just write to SQL Server?

John Esraelo-498130 SSCertifiable Points: 5916 More actions · Answer 5

The link between the two servers may not be available at all times, imperfect world, thus the transactions can be locally preserved for that matter.

🙂

Cheers,
John Esraelo

theof1821 Grasshopper Points: 10 More actions · Answer 6

Regarding the vfp odbc driver, I 'd like to mention that there's also a new VFP ODBC Driver released as part of the Advantage Database Server Version 9.0 (Beta) which is fully compatible with VFP 9.0 Data.

For anyone who is interested, you can follow these links :

You can download the driver from the Advantage website here: http://devzone.advantagedatabase.com/dz/content.aspx?Key=20

and also read some related information of FoxWiki site (wiki about Visual Foxpro):

http://fox.wikis.com/wc.dll?Wiki~VFPODBCDriver~SoftwareEng

One last suggestion : If someone wants to synchronize data between VFP and MSSQL, there is also the option to create a servise with VFP which would have the responsibility to check and update data on both sides.