Transfer Foxpro Database To SQL Server

Question

How to Transfer Foxpro Database To SQL Server ?

score 2 · Answer 1 · answered Mar 04 '11 at 19:59

2

You can use the upsize wizard, see here http://support.microsoft.com/kb/129847

answered Mar 04 '11 at 19:59

SQLMenace

What if you're not fortunate enough to have a copy of foxpro? – Zach Mar 08 '11 at 21:18

score 0 · Answer 2 · answered Mar 06 '11 at 02:11

0

You might also want to look at the Sedna Upsizing Wizard Update on codeplex at http://vfpx.codeplex.com/wikipage?title=Sedna#SQLServerUpsizing

answered Mar 06 '11 at 02:11

stuartd

score 0 · Answer 3 · answered Mar 07 '11 at 09:39

0

If you are moving a large amount of data, I would recommend SQLXMLBulkLoad. Doug Hennig wrote about it and has sample code at http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html

answered Mar 07 '11 at 09:39

Frank Perez

score 0 · Answer 4 · answered Dec 15 '11 at 20:04

0

Another option, if you are using SQL Server, is to use a Link Server to access your VFP database without having to convert it to SQL Server.

answered Dec 15 '11 at 20:04

Jerry

4 Answers4