• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JSP with Visual Foxpro Project

 
Ranch Hand
Posts: 265
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic