Firebird data export

[werkstattboss]

Hello,
there are hints to a data export / import functionality in IBDac, at least in Version 2.0.

I need to move data between different databases and I would prefer a solution from inside the program (VCL) over an external one (fbexport).

So my question is, whether there is such a function and where I can find it.
I use D 2007 / XE / XE2 with IBDac

TIA
Rolf

[werkstattboss]

Hi again,
if there is no built in replication that´s sad but ...
Another way to realize that would be to record all SQL Statements executed during a session and execute them as a script on the other DB / Table.
How can I (if possible) get the SQL statements that are executed?
I have some parameterized queries.
I would have to change them if I can´t get the statement with the parameters replaced by values from inside the program.

TIA

Rolf

[upscene]

Have you take a look at our IB LogManager product? Check out www.upscene.com

[ZEuS]

You can use the TIBCSQLMonitor component to record all executed SQL statements, then modify them according to your needs and execute them using the TIBCScript component.
With the TIBCSQLMonitor component you can use the Devart dbMonitor tool, which allows to save the log output to a file. Then you can parse the file data to create a script for executing in the TIBCScript component.

[werkstattboss]

I guess that´s what I was looking for.

Thank you

Rolf