Sean

> I have a firebird database with a table containing a large number of large
> images. I want to reduce the file size so i converted all the images to a
> smaller size but the file size did not reduce. Is it necessary to repack a
> firebird database or table?

Only a database backup/restore compresses the physical database file. Internally, as pages are emptied, they are assigned to a free page pool, for use by any other table as needed.

> If i create a new database, is there a convenient way using sql to copy tables
> from the old database to a new database - my sql capabilities appear to be
> too restricted for that.

There are "move" tools available for that. Have a look at the IBPhoenux.com site (Downloads | 3rd Party Tools) for a list of available options.


Sean