Conversion of Foxpro6.0 to SQLServer 2000

800K tables are not that big for Fox. Sounds like some optimization of the
queries may help, but without know what you are doing, it's hard to say.
However, there is a rule of thumb that moving to SQL Server just to get
speed increases won't help. VFP is extremely fast and can be as fast as or
faster than SQL Server in some cases.

--
Craig Berntson
MCSD, Visual FoxPro MVP
Author, CrysDev: A Developer's Guide to Integrating Crystal Reports
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org

"Anoop Ravi" <kran@sonata-software.com> wrote in message
news:3ef7f5f7@tnews.web.dev-archive.com...
>
> Hi,
>
> We have a product developed in VFP 6.0 with tables in Foxpro itself. We
need
> to move some of the heavy tables (of size around 800K) to SQL server and
> the report queries (which are right now in Foxpro classes) into Strored
Procedures.
>
> we have the following doubts regarding this.
>
> 1. Is there anyway we can automate this process? Any tools available?
> 2. An other suggestion was to create the SQL and pass it as string from
> FoxPro to SQL using SQLExec. Does this work faster?
> 3. By any chance optimization of the existing foxpro Query is going to
help
> for this kind of heavy data?
>
> regards
>
> Anoop Ravi
>
>