Notes
Outline
Upsizing FoxPro Applications to SQL Server
Ted Roche, MCSD
Director of Development
(781) 663-7400
http://www.bstone.com
Slide 2
FoxPro: It’s Not Just a Dot Prompt Any More…
Fox Software purchased 3/1992
More products from the group
Visual FoxPro:
Object-Oriented Programming
Powerful local data engine
Full support for OLE and ODBC
What Does VFP Provide?
SQL: ANSI-92 Insert, Update, Select, Delete
SQL Passthrough
Views: local, remote, offline
Buffering and Transactions
Database Container for triggers, rules, relational integrity
Powerful, well-known Xbase language
Why not a Pure Fox solution?
Security
24 x 7 availability
Low Bandwidth situations (Internet)
2 Gb file limit
Tiers of a clown
One-tier, two-tier, n-tier, blue-tier
ADO, RDO, DAO, DMO -
I don’t know!
Classic File-Server
Classic Client-Server
n-Tier
Upgrading FoxPro 2.x apps to VFP
Backward compatibility: run as is
Conversion to VFP:
Functional
Visual
Using FoxPro’s Transporter & Conversion Facilities
DEMO
Upsizing VFP apps to client-server
Upsizing Wizard
Create new data store
Convert views from local and remote
Conversion of schema
FoxPro facilities
Third-party tools
DEMO
Conclusion
Visual FoxPro is more than DBFs:
Robust programming language
Powerful local data engine
Conversion to SQL Server can be incremental:
Code Conversion
Schema Conversion
Port to n-tier
Slide 13