Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Syncing Remote SQL data with Local VFP 8 Data Problem
I need some help thinking through a sticky syncing problem.
My company has a commercial software package Mailorder Manager (MOM) based on a VFP 5.0 database (there is a new version based on VFP 8.0 that we have not upgraded to). We do not have access to MOM’s code.
Online, we use an online shared SQL Server 2000 in which we cannot be given admin rights. Thus SQL replication is not possible.
We are hoping to have "almost live" inventory levels online based on the inventory levels in our local MOM VFP Inventory table. These local inventory onhand levels change throughout the day as we do retail and mailorder along with web orders.
Our local VFP table does not have a time/date stamp. Thus we do not know what records have changed.
Can someone point me in the right direction for syncing and automating this process?
Thanks!
Suivant
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