java - MySQL Commands into .DBF Tables -


i writing database system in java writes , reads mysql database hosted on xampp. system , running using mysql commands select, update, add, delete etc.

the issue using old database written in visual foxpro has tables stored .dbf files. rather taking few years working system , moving on mysql system @ once, have both systems working concurrently gradually more people beginning move on , use mysql system.

this having issues. there way both update mysql table , .dbf file when job added through java program? simple using mysql command directly modify file? understand there possibilities in python or php have never learnt either of these languages , prefer easier solution.

trying keep 2 databases in synch bad idea. if miss , data no longer matches, how know right? (a man 1 clock knows time is; man 2 never sure.)

if existing system complex enough, maybe consider moving 1 module @ time.

if existing system well-written, might possible switch work mysql without effort. said, experience few applications enough designed , written make simple task.

alternatively, might set new system kind of wrapper talks existing dbfs until you're done , can switch mysql.


Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -