We had a guy, Mark Murphree, at out last SIG (http://www.hal-pc.org/~jpc/HAL-PC/foxmain.html) that showed us how he is doing it for Burr Wolf. He used the upsizing wizard for some stuff and he had another object that went through his PRGs (if I remember correctly) looked for his SEEK commands and the created a table that another program could use to write SQL SELECT statements back to a PRG, i think. It was one of the coolest conversion schemes I had seen!

You might ask him in an email for advice. His UT ID#011470. I could not find a thread he had participated in!
HTH


>I have an app that currently uses Fox2x tables. I want to redesign
>the app in 2 stages.
>
>First, I want to rebuild it in VFP, using the same tables. Next,
>I want to convert the app to SQL Server.
>
>I'd like to create a data layer that I can just swap out when the
>time is right, but I'd like to minimize the amout of changes that
>would be needed in the forms and other areas.
>
>The data layer would simple return the requested recordset, either in
>the form of a SQL command in VFO against native foxpro tables into a
>cursor, and then later against views and/or updatable recordsets.
>
>So, in practice, a form could call a procedure to get the desired recordset
>from the data layer. But what format do I return it in that would work with
>both forms of database?
>
>I'd really like to code the forms once and only have to deal with the data
>layer.
>
>Thanks