Hi there,

I've got lots of tables in my Pervasive database. Now I want to export
the data. I want to create a script-file which contains to data and
that uses 'insert into' statements (I've got a script for the 'create
table' statements) to allow to import all the data into another
sql-database. For MySQL there exists mysqldump - but for Pervasive?
Are there any open source tools?

Thanks,
Markus

Our SQLEXEC tool provides the ability to run SQL Statements from the
command line. While it cannot directly generate the "INSERT INTO"
statements during the export phase, it can implement the INSERT INTO
statement on your behalf.

Here's the options currently available:

SQLEXEC Version 1.81.1918: 05/19 (C)2004 Goldstar Software Inc.
*** Registered 32-Bit Version ***.

Usage: SQLEXEC <DSN> ["Statement"] [/options]
This command executes SQL Statements Against a DSN.
<DSN> is the ODBC Data Source Name with which to connect.
"Statement" Is the optional SQL statement to execute (up to 16K chars).
/U<username> specifies an ODBC User Name to use (Default=Master).
/P<password> specifies an ODBC Password for this User Name.
/C<filename> to read a connection string from a file instead.
/M<filename> executes multiple statements from the given filename.
/I<filename> uses a data import file (SDF) in an INSERT statement.
/S<symbol> specifies the separator symbol in the input file.
(Default=#)
/B Enables Blank Processing (Eliminates Trailing Spaces From Data).
/Ox changes Output format (F=Fixed, T=Tab-Separated, B=Bar-Separated).

(C=Comma/Quote-Delimited, R=Raw Comma Delimited,
S=FS/RS-Delimited).
/H Disables the Column Header Row.
Field Filtering Options: (Add multiple option values together, if
needed.)
/F1 Change CR/LF to space character.
/F2 Change Null byte (0) to space character.
/F4 Change control characters (1-31) to space character.
/F8 Clear high bit on every character.
/F16 Force all text characters to UPPERCASE.
Error Logging Options:
/EO Logs Errors to StdOut. (Default is logging to stderr.)
/EL[file] Logs to SQLEXEC.ERR or optional text file provided.
/EC[file] Logs to SQLEXEC.ERR [or file] as Comma-Separated Values.

/D Enables Debugging Output.
(Single-letter options can be combined.)


While originally built to hit Pervasive.SQL, this tool can be used to
access just about ANY ODBC-based data source.

See our web site for more info at www.goldstarsoftware.com/sqlexec.asp
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!


Markus Brandy wrote: