>I want to change backend of a large application developed in VFP 6 to SQL Server and also upgrade to VFP 9, to take advantage of the latest features for upscaling.
>
>I want to make minimum changes to code, as the application is very large. All my Reports are form & grid based & use vfp sql and am using a form class for all Masters.
>
>I tried using CursorAdapter class, but the schema becomes to long (more than 255 characters is not accepted).

This is a problem in the Property Sheet prior to VFP9, and not the CA. You can have schemas as long as you need, but you would have to set that property using code in the init of the CA.

>Is CursorAdaptor with ADO the best option in my case? How do I get around the abovementioned problem?

ADO will not work around that problem either unles you are using VFP9.

I have a free CA builder that wil create a class library (VCX) that will have a subclassed CA for every table in your SQL Server database. The source code is included and has extensive comments on how to use it and the generated VCX near the beginning of the CABuilder PRG file. You can get it by clicking the FoxPro Tools link at http://www.mctweedle.com