Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Synch up VFP data with a SQL Server
Anybody ever tried to synch up VFP 7.0 data with SQL server 2000?
We have a client, and they want to synch up a bunch of our VFP tables (living in New York City) with their SQL Server in L.A. over the internet. This is to accomplish a Data Warehouse task.
Anyone ever had any success with this? We already audit Inserts, Updates & Deletions on the tables they want, via triggers. This information is stored in a master audit table, with the primary key, the table name and the field(s) that have been changed. The master audit table also has the type of change (I/U/D).
The problem they are having is with remotely connecting to our VFP tables and querying them. Several tables are rather large (in the 1.0 to 1.6 GB range). Their .CDX's are also pretty big. They are trying to run SWL queries, and are having bad results as far as time goes; they say it's way too SLOW.
Any thoughts at all? We don't even know where to start.
Thanks.
- George E. Mamunes
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