Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update SQL table from VFP table
Message
De
01/09/2015 15:31:16
 
 
À
31/08/2015 11:51:19
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01623948
Message ID:
01624116
Vues:
65
>Chris,
>
>>>I need to update a SQL Server table with values from a VFP table.
>
>VFP's Remote View provides an easily reproducible and accessible mechanism to do this. Even with no experience a developer can create an updateable RV against a SQL Server table in as little as a minute. After that you can simply USE the Remote View NODATA (use the NODATA because unless you specify a filter in the RV, it will pull across the whole SQL table!)
>


As I said to Chris, there are multiple ways to do this. Remote Views would likely work, though it wouldn't be high on the list of recommendations.

If he's going to invest time in a solution, SSIS is a better investment of time. It can handle this situation, as well as many others.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform