A database migration project consists of four phases:
We map the existing structure of the tables to the target database. From the application viewpoint, the behavior will be the same as the source database.
We translate the database logic in the form of stored procedures, triggers and views. The new database will also contain the old database's system tables.
All of the logic and table structure script is implemented using dbPORTER. This tool connects the old and the new database, working as a migration tool and a data-pump. It creates the new structure and pumps all of the existing data to the new database. The process is then verified and a comprehensive log is generated.
As the dbPORTER tool is available throughout the development, test migrations can be performed at any time. After this work has been completed, all of your installed databases will be migrated.
The sqlTRANSLATOR middleware is integrated into the application as an ADO.NET data provider and during run time translates the .NET application's SQL statements into the target database's syntax.
We're mainly focusing on migrations involving OpenTextTM SQLBase and IBM Informix as the source platforms and SQL Server, Microsoft Azure SQL database and Oracle as the target databases. Let us know if you'd like us to assess additional databases within the context of a project. We also offer the dbPORTER and sqlTRANSLATOR tools at a fixed price as part of a porting project.
The simple fact that we can now operate around the clock without a maintenance window is a significant advantage for our business processes.