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 Re****ts, 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@[EMAIL PROTECTED]
Chicago: Pervasive Service & Sup****t Class - 07/2007 ***
smeis wrote:
>
>
> I have a Pervasive SQL 9.5 Server with a database that I am trying to
> ex****t data from. The "Ex****t 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?
|
