Upsizing FoxPro Applications to SQL Server
| Ted Roche, MCSD | |
| Director of Development | |
| (781) 663-7400 | |
| http://www.bstone.com |
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 | ||
| 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 |
| Security | |
| 24 x 7 availability | |
| Low Bandwidth situations (Internet) | |
| 2 Gb file limit |
| One-tier, two-tier, n-tier, blue-tier | ||
| ADO, RDO, DAO, DMO - | ||
| I don’t know! | ||
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 | ||
| 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 | ||