• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP with Visual Foxpro Project

 
Aravind Prasad
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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 ]
 
Aravind Prasad
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic