This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes JSP with Visual Foxpro Project Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSP with Visual Foxpro Project" Watch "JSP with Visual Foxpro Project" New topic
Author

JSP with Visual Foxpro Project

Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 263
Dear Ranchers,
I'm now doing an onsite project in a Logistics Company. They are using a Software which is developed in Visual Foxpro 6 and the database they are using is visual foxpro with the extension dbx.
Due to the increase in the clients, they want to put a track and trace into the webbased solution. They have a domain registered and the Service Providers told to give the JSP and MySQL support. The remote server is Linux machine.

My Questions are

1) How can i synchronize the Foxpro databse to MySQL database

I've found one software in the internet and, it costs $55.

Or can i run the program in the remote machine and put the database in the local server like


Please give me a good idea.. for my career..

Regards

Aravind Prasad
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


1) How can i synchronize the Foxpro databse to MySQL database

Not sure what you are trying to do here - by "synchronize" are you looking to replicate the data in the foxpro database in MySQL? Do you want intend to keep using the foxpro database? Or do you just want to know how to do a one-off transfer of the schema?

Sun's driver database lists a bunch of drivers for foxpro.

(I'm suprised your customer is continuing with foxpro, since Microsoft is making noises that they are discontinuing it)
[ March 28, 2007: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Aravind Prasad
Ranch Hand

Joined: Dec 28, 2005
Posts: 263
Dear Paul,
Thanks for the reply. I don't know why my client is still continuing with Foxpro. I've found a software in internet which can synchronize the foxpro database with remote mysql database. I've tested. Since it is a trial version, I can only get 10 rows from each table. The software name is FoxPro2MySQL Sync.. I'm planning to buy this Software..

Regards

Aravind Prasad
 
jQuery in Action, 2nd edition
 
subject: JSP with Visual Foxpro Project
 
Similar Threads
Accessing Foxpro table using servlerts/jsp
DATABASE INITIALIZATION
Freelance Developer
passed SCJP2 with 83%..........
You are Right-A Beginner