SQL: Convert dbase to sql
Posted on 2006-06-23
After a little primer on SQL from Todd Farmer, I am wondering how software vendors convert a dbase database into SQl. I work with the dbf's and mix them with Access but when this fellow was demonstrating his software, I asked how he accessed the dbf's. He said they convert it to SQL.
So, my questions are:
1.) How can one convert dbf to sql on a (almost) live basis? I know White Town Software sells a converter but can it be done on the fly, instantly?
2.) Does the (1) conversion and the (2) querying occur sequentially in that order?
from the "Educating Charlie Project",