I was wandering too, if I can execute a complete sql script, instead line by line. Something like Oracle instruction @c:\script.sqlIf you have a script for sql*server or oracle -- convert it to a vfp program and run that program. Now of course, you have to do a lot of translation of data fields and syntax so it might be a lot of work!
Maybe some data modeling tools can take the oracle script, convert it to a schema and then translate it to VFP. Maybe xcase (
www.xcase.com) can do that -- I don't know.
Kevin