SQL Server Programming for Visual FoxPro
An advance course aimed at Visual FoxPro programmers who want to use Microsoft SQL Server as a back-end database.
This course provides a rapid introduction to SQL Server programming for VFP developers. It covers the practical aspects of designing and building efficient SQL Server databases and integrating them with VFP applications.
Suggested length: Three days
Delivery
We can bring this course to your site, anywhere in the UK, the rest of Europe, the USA or Canada. The course is also available for one-to-one training at our office in Edinburgh. For further information, please see Overview of training options.
What you will achieve
At the end of the course, delegates who meet the pre-requisites will be able to plan, design and create robust VFP applications that fully exploit the power of a SQL Server back end.
Pre-requisites
To benefit from the course, you should have experience of developing applications in Visual FoxPro and be fully familiar with VFP's data-handling and querying features. You do not need any previous knowledge of SQL Server.
Course contents
Introduction to SQL Server
- How SQL Server and VFP fit together
- SQL Server tools: Management Studio, Enterprise Manager, Query Analyzer
- Introducing the T-SQL language
Designing and building a database
- Principles of efficient database design and deployment
- Creating databases and tables
- SQL Server data types
- Indexes and constraints
Migrating Visual FoxPro data to SQL Server
- The VFP Upsizing Wizard
- Data Transformation Services / SQL Server Integration Services
- Other ways of migrating data
Using VFP as a front-end to SQL Server
- Configuring data sources and connections
- Using remote views and cursor adapters to access back-end data
- Modifying server data from within VFP
- Using SQL Pass-Through to access the server
- Error-handling
- Designing an efficient client-server application
Programming for SQL Server
- T-SQL as a procedural language
- Batches, transactions and triggers
- Using T-SQL to write stored procedures
- Executing stored procedures from within VFP; parameter passing; returned values
- Understanding system procedures.
Version
The course is equally applicable to SQL Server 2000 and SQL Server 2005, and to Visual FoxPro 6.0 to 9.0.