( 1 reviews )
-
Posted: Sep 27 2006
This book provides one of the best references available for integrating Visual FoxPro and SQL Server. There are few guides for the Visual FoxPro Developer in how to create multi-user applications in Client/Server Mode. Urwiler, Dewitt, Levy, and Charon have teamed up to write a book that fills a large gap in the VFP to SQL Server integration area. The book provides a step-by-step process that is simple enough in format to understand and basic enough to put in practice with little previous SQL Server experience. The authors begin with a quick overview of client/server, basic database design and theory before moving into the more complex tasks of upsizing and connectivity. There are plenty of code examples and appropriate illustrations. As a book targeted towards the VFP programmer the authors do a fairly good job. The four coauthors provide tips and point out problem areas and pitfalls to avoid. There are helpful hints for using GenDBC a utility program the ships with VFP to refine remote views. While the book covers the entire subject of integration well, the better features of interest are the contrast and comparing of VFP and SQL Server database architecture. Some of the book's best sections of interest include: Using SQL Server Security Connecting to the Database Server with Remote Views Working with ODBC Optimizing View Performance Connecting to the Database Server with SQL Pass-Through Once you finish reading the book, many of the your questions regarding SQL Server integration will be answered. This book is a great introduction to SQL Server. But for the more complex operations of performance tuning and optimizing, there are better books available. The book is easy to read but leans toward the technical. Be warned this is a technical book and while some technical books not only instruct but entertain. This is not one of them. This is written in a no nonsense and get-down-to-business style. If you want a light read look else where, but if you need to upsize your VFP database and do it quickly look no further.
