I need to migrate from Foxpro 2.6 to Visual Basic 4.0!!!!!!!

[Guest_imported]

I have an application in Foxpro 2.6 for Windows and now we have to migrate it to Visual Basic 4.0 and SQL Server 6.5. Does anybody have guidelines, tricks, software to convert, etc.?

 

[foxdev]

Hmmm...going from a 3-version-old edition of FoxPro into a 2-version-old edition of VB and a 2-version-old edition of SQL Server - doesn't seem like progress, but I imagine you weren't given much choice, sconcha.

Data-wise, you could write out the non-memo FP data to text files and use BCP to import it into SQL Server. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[jpugh]

If you have access to VFP, you could also use the &quot;Upsizing&quot; wizard to move the data to SQL server.

Jon Pugh
[sig][/sig]

 

[infinitelo]

keep in mind visual basic can access foxpro 2.6 dbf's!

It may even have the utility to convert to sql (havent tried it myself.)

 

[rgbean]

While others have concentrated on the data conversion, I'll try the application. Either from the detailed program specs or very close observation, know what the FPW program does and rewrite to do the same thing in VB4 <s>. There are no utilities that can do this for you. While you might be able to &quot;save&quot; some basic algorithms, the coding methodology - especially when introducing SQL server into the mix - is totally different. Even the way of specifing forms, menus and reports is totally different. I wish you much luck.

Rick

 

[infinitelo]

rgbean has a very good point. the code is going to be the tough part. is this a large application? how much time do you have for the project?