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
Post a Comment