I have a Pervasive SQL 9.5 Server with a database that I am trying to
export data from. The "Export to File Wizard" works fine for each
table individually; however, I need to do this repeatedly. Is there a
command or series of commands that I can use in the query window to
accomplish this?

Pervasive provides base capabilities in their tools. As they produce
database software designed for software developers, they sometimes
assume that most people using the system are developers and will be
able to build their own tools.

In short, any ODBC-based tool should be able to extract the data. This
would include MSAccess (to the degree that it is ODBC compliant),
SQLServer/DTS, Crystal Reports, and more. A quick search of the
Internet will likely turn up these and other products, some paid, some
free, that can do what you need.

At Goldstar Software, we wrote our own tool (SQLExec) that also fills
this need. It can easily execute SQL statements, including stored
procedures, data modification statements (INSERT/UPDATE/DELETE), and
data extraction statements (SELECT) to multiple delimited data formats
-- all from the command line for use in batch files and other such
scripts. You can find more information about this tool from
www.goldstarsoftware.com/sqlexec.asp. If you would like a trial
license to play with, let me know via Email and I'll get you a copy.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2007 ***

smeis wrote: