09/09/2003 Jump Start Database Design with xCase Mike Feltman

xCase is a powerful CASE tool that can be used to design databases for Visual FoxPro, SQL Server and other data sources. In this session Mike will demonstrate how to use xCase to design a database and its many benefits to developers and other parties involved in the database project.

Mike Feltman's main topic SQL Server Data Access Techniques with VFP8

Visual FoxPro offers numerous means of accessing remote data. These include Remote Views, Dynamic SQL Pass Through, SQL Pass Through calling Stored Procedures. Visual FoxPro 8.0 provides yet another means of accessing remote data with the Cursor Adapter class, which actually can wrap the other techniques. In this session we'll look at the pros and cons of each technique and discuss when each of these techniques are the most appropriate for a given situation. The discussion will focus on Ease of Use, Performance and Scalability, Maintainability, Flexibility and Security for each approach. This discussion will be specific to SQL Server and MSDE but will be equally applicable to other back-end data sources.