|Subject||Re: [firebird-support] Copy Table|
> I want to create monthly backups of some tables by executing a procedure.Unfortunately, Firebird doesn't support the CTAS (CREATE TABLE ... AS
> For ex, lets say I have a table named as COMPANY, and every month I want
> to create a backup table named as COMPANY_BCK_2014_01,
> COMPANY_BCK_2014_02 and copy the existing data into these backup tables.
SELECT ...) syntax.
Feel free to vote on that tracker issue:
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.