Migration Framework for Firebird

Migration Framework for Firebird: A Comprehensive Enterprise Solution

The Migration Framework for Firebird is an integrated suite of tools and guidelines designed to automate a substantial portion of the database migration process. It provides a streamlined methodology for automating of Firebird migration workflow.

Utilization Scenarios for the Migration Framework

Enterprises managing numerous databases across multiple servers and locations face the daunting challenge of complex migrations. The Framework delivers a proven, reliable solution for large-scale migrations, demonstrated in the successful transition of over 600 servers. It enables organizations to expediently migrate all servers in a fraction of the time typically required for manual migration efforts.

How Migration Framework for Firebird works?

  1.  Metadata Analysis: The Framework conducts an automatic examination of database metadata backups, producing a comprehensive report that identifies issues. Detected problems are categorized into those that can be resolved automatically and those necessitating manual intervention.
  2. Data Migration Execution: Following the verification and potential adjustment of metadata, the Framework facilitates an automated conversion process. This involves simply transferring a set of files, placing databases in the legacy format into the designated incoming folder, and subsequently retrieving the fully operational database from the outgoing folder
Try it now - the first migration is free of change! See User Guide for details.

Examples of automatic changes

The Framework will analyze and automatically fix the following problems in meatada:

Incompatibilties in stored procedures, triggers, functions, packages, view

  • SUSPEND without return (only procedures)
  • Usage of CURRENT_TIMESTAMP (now with TIMEZONE)
  • usage of LOCAL (reserved word)
Example
-- before
create or alter procedure sp_sample
as
begin
  insert into tablex (start_time, user, local) values (current_timestamp, current_user, 1);
  suspend;
end
-- after
create or alter procedure sp_sample
as
begin
  insert into tablex (start_time, user, "LOCAL") values (localtimestamp, current_user, 1);
  --suspend;
end

Usage of CURRENT_TIMESTAMP in computed fields

Example
--before
alter table TABLEX alter column COLUMN1 computed by (CURRENT_TIMESTAMP)
alter table TABLEX alter column COLUMN1 computed by (CURRENT_TIME)
--after
 
alter table TABLEX alter column COLUMN1 computed by (LOCALTIMESTAMP) alter table TABLEX alter column COLUMN1 computed by (LOCALTIME)

Use of CURRENT_TIME/CURRENT_TIMESTAMP in DEFAULT clause of fields

Example
--before
ALTER TABLE CLIENTE ALTER COLUMN DT SET DEFAULT CURRENT_TIMESTAMP
ALTER TABLE CLIENTE ALTER COLUMN DT SET DEFAULT CURRENT_TIME
--after
ALTER TABLE CLIENTE ALTER COLUMN DT SET DEFAULT LOCALTIMESTAMP
ALTER TABLE CLIENTE ALTER COLUMN DT SET DEFAULT LOCALTIME

Automatic Actions and Fixes for Dialect 1 to Dialect 3 Migration

  • Execution of gfix to dialect migrate
  • Use of double quotes in PSQL blocks changed to single quotes automatically
  • Replacement of CURRENT_DATE (date and time in dialect 1) to LOCALTIMESTAMP (date and time in dialect 3) everywhere inside database

Licensing Information

The Framework is licensed per successful database migration.
The trial version includes 1 free migration, so you can download it, perform the test migration, and evaluate your applications against the migrated database.

For further migrations you should purchase the license, accroding the number of planned migrations.
Read User Guide for more details.

The support is optional, it is recommended to purchase it only for complex cases.

Price Number Of Bases Optional Support Purchase now:
USD$99 1 Migration USD1300 (optional) Purchase Here
USD$395 Up to 5 Migrations USD1300 (optional) Purchase Here
USD$690 Up to 10 Migrations USD1300 (optional) Purchase Here
USD 1000 Up to 50 Migrations USD1300 (optional) Purchase Here
USD$2750 Up to 250 Migrations USD1300 (optional) Purchase Here
USD$3000 Up to 500 Migrations USD1300 (optional) Purchase Here
USD$10000 Up to 10000 Migrations USD1300 (optional) Purchase Here
  Need More? Contact Us.    

Contact us: [email protected]
Migration Framework User Guide is here (PDF).