Home > IT Answers > Development > migrating from foxpro to SQL7.
Namitgrover
5 pts.
 migrating from foxpro to SQL7.
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.

Software/Hardware used:
ASKED: January 4, 2008  6:44 AM
UPDATED: January 31, 2008  10:15 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  January 4, 2008  8:55 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.
 

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

Proware
 10 pts.