migrating from foxpro to SQL7.

5 pts.
Tags:
FoxPro
Migration
SQL
Visual FoxPro
Hi All, I have around 95 tables on FoxPro that I need to migrate on SQL7. These tables are stand alone data tables and are not part of any database as of now. I have tried exporting these tables into XLS format and then importing these tables to SQL7 using enterprise manager but there are certain constraints that i face in excel and also this would be a bit cumbersome process for 95 tables. Second option under consideration was a freeware that could enable me to migrate from FoxPro -> SQL7. or third option as suggested by one of my colleagues FoxPro->Visual FoxPro -> SQL7. I am looking for either the driver, if somebody can point me towards it or way of migrating stand-alone data tables from FoxPro to Visual FoxPro. Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you have the FoxPro drivers you should be able to use the import wizzard to import from FoxPro directly to SQL Server.

Why are you going into SQL Server 7? SQL Server 7 has been end of lifed. You should really look into moving it into at least SQL Server 2000 or SQL Server 2005, maybe even SQL Server 2008 as it’s being released in about 4 weeks.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,140 pointsBadges:
    report
  • Proware
    You can also create a Data BAse Container (DBC) in Visual Foxpro and add all the tables to the DBC then use the Upsizing wizard to send it all to SQL. Cheers David
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following