Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Minimizing code changes when moving to SQL Server
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Minimizing code changes when moving to SQL Server
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01071761
Message ID:
01071761
Views:
59
I'm beginning a migration of our application from using VFP tables to using SQL Server. Rewriting the biz objects isn't too difficult since I've got some basic table insert/delete/update code. I've got a lot of report code though that for speed reasons, accesses the VFP tables directly to pull data. How can I minimze the changes to the report code when migrating to SQL Server 2005? Can I create a FoxPro remote view on the fly at the start of each report, that references the SQL tables, then from then on the code thinks it is accessing VFP tables?
Next
Reply
Map
View

Click here to load this message in the networking platform