Tutorial eBooks PDF File Download

Microsoft ® SQL Server™ offers the database developer incredible power and flexibility, but learning to work with it is a lot like learning to play chess. The basics are easy, but mastering the product takes some effort. This white paper will not discuss SQL Server in-depth, as there are many excellent books already available on the subject. Instead, I will discuss the basics of migrating your monolithic Microsoft Visual FoxPro (VFP) application to a client/server platform, specifically with SQL as the database. To that end, I will cover the following: Conversion issues – what do your users expect, what do you hope to accomplish with the conversion, and most importantly, can your application be converted? Data conversion – what design issues will you face, and what are some of the differences between SQL-stored data and VFP-based data. Data Access Techniques – how do you access SQL-stored data from within VFP? We will investigate remote views, SQL pass-through, ADO, and how they compare with each other. System design issues – what are some of the more important performance and “mechanical” issues you will need to consider? Supporting your application – how to deal with table changes, updates to the code, error reporting, and so on. This topic is often ignored, but is just as critical as deciding how you’re going to get to the data.