Conversion of Foxpro6.0 to SQLServer 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Conversion of Foxpro6.0 to SQLServer 2000

  1. #1
    Anoop Ravi Guest

    Conversion of Foxpro6.0 to SQLServer 2000


    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



  2. #2
    Craig Berntson Guest

    Re: 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.devx.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
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center