Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to run an sql script file?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00509146
Message ID:
00509625
Views:
23
I was wandering too, if I can execute a complete sql script, instead line by line. Something like Oracle instruction @c:\script.sql

If 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
Kevin Emmrich
www.jkt9000.com
Previous
Reply
Map
View

Click here to load this message in the networking platform