Re: [Error]Import data from vfp to sql server !

From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 14:37:21 GMT

Hi Agnes:

Do you have a copy of Visual FoxPro? If so, then try using the VFP
Upsizing Wizard to convert the tables into SQL Server.

If you are running VFP 7.0, you may want to get the updated Upsizing Wizard
from this web site:

http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
   http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
   http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
 
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
   - VFP5 Mainstream Support retired June 30th, 2003
   - VFP6 Mainstream Support retires Sept. 30th, 2003

>I am using ODBC, for another small database( got 10 tables) , i am import
>succesfully, now for a bigger database( 30 tables, some tables got over
>10,000 records) it seems fail.
>Please help.
>>From Agnes

>"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> ¦bl¥ó
>news:eFqsvxAOEHA.3672@TK2MSFTNGP11.phx.gbl ¤¤¼¼g...
> Hello, Agnes!
> You wrote on Wed, 12 May 2004 18:20:39 +0800:
>
> A> i have one database which got 30 tables,
> A> I want to import these data into sql server,
> A> I found that during "import ", there are Error occured, why ?
> A> Moreover, for one specific tables, the sql server seems 'hangs", i had
> A> wait over 3 hrs.
> A> the process seems held or dead , I need to use task manager to end up
it
> A> . Does anything wrong in my tables ??
>
> How are you sending the VFP data to SQL? Are you using the SQL "DTS
> Import/Export" tool? Are you using ODBC or OLEDB?
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>

Relevant Pages

  • Re: Local View vs Remote View
    ... view for SQL Server tables or the one containing the remote view for VFP ... I'm trying to create forms which will handle both VFP data and SQL Server ... The VFP tables used in this case are counterparts of the ones used ...
    (microsoft.public.fox.helpwanted)
  • Re: Fatal Error when using Free tables in VFP 9.0.beta
    ... If it's a network problem, whether it's a free table or in a .DBC will make ... >> Microsoft Visual FoxPro MVP ... >>> I am currently evaluating VFP 9.0 beta version. ...
    (microsoft.public.fox.programmer.exchange)
  • [NT] FoxPro ODBC Driver Buffer Overflow via SQL OpenDataSource()
    ... OpenDataSource function in Microsoft SQL Server when we are connecting to ... "Microsoft Visual FoxPro Driver". ... we can overwrite EIP register with any value. ... SELECT * FROM OpenDataSource('MSDASQL','Driver=Microsoft Visual FoxPro ...
    (Securiteam)
  • Re: SV: Fox to SQL Server
    ... I use Agent too, and I see the same thing. ... Anders' replies have 'SV:' prepended to the subject. ... >>Another way is to create a connection in a VFP datebase to the SQL Server DB ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Local View vs Remote View
    ... Some data will be from SQL Server and some from VFP. ... be accessed using ODBC remote views. ... Table1 and table2 have structures ...
    (microsoft.public.fox.helpwanted)