>> In Firebird 2.5 you will be able to do this in PSQL, using the enhanced EXECUTE STATEMENT features. Download it and give it a try.
>
>
> Well, I need on a production enviorment so ... may be another time ;)
>
> I will try to find another solution.

You could use an "ETL" product. We are using Pentaho Data Integration
(PDI) (formerly known as Kettle) for moving data from an OLTP into an
OLAP database.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/