Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2007, 12:42 PM
Registered User
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default CONVERT VISUAL FOXPRO TABLES TO SQL SERVER

I have visual foxpro dbf files with huge data. I am migrating from DOS prog. to .NET. Help me how to convert .dbf files to sql tables/database


N.V.ANANTHA KRISHNA
Flat No. 504,
RV Pranathi Apts.,
Road Beside Chandana Bros.,
Behind Ravindra Bharathi school,
Hyderabad 500 060
 
Old June 25th, 2007, 12:30 PM
Registered User
 
Join Date: Jun 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is a wizard in VFP that does this, but you must test it because it isn't perfect.

The other thing you can do is create an ODBC connection to your FoxPro tables, then write an application to write all your data from ODBC datasets into SQLdatasets. You have to create your SQLserver Db first of course

Does any of this help?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Link FoxPro tables through OLEDB catudalg Access 2 May 8th, 2007 08:16 AM
visual foxpro programming manoharan BOOK: Beginning XML 3rd Edition 3 November 10th, 2006 04:12 AM
visual foxpro programming sqsean BOOK: Beginning XML 3rd Edition 0 May 3rd, 2006 05:36 AM
Visual foxpro dilipdamodaran BOOK: Beginning XML 3rd Edition 0 April 26th, 2006 04:20 AM
why Visual FoxPro ? badgolfer Other Programming Languages 0 December 8th, 2005 11:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.