Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update SQL table from VFP table
Message
From
01/09/2015 15:31:16
 
 
To
31/08/2015 11:51:19
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01623948
Message ID:
01624116
Views:
66
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform