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
