|RE: [firebird-support] Packing of firebird database
> I have a firebird database with a table containing a large number of largeOnly 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.
> 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?
> If i create a new database, is there a convenient way using sql to copy tablesThere are "move" tools available for that. Have a look at the IBPhoenux.com site (Downloads | 3rd Party Tools) for a list of available options.
> from the old database to a new database - my sql capabilities appear to be
> too restricted for that.